I am using
VLOOKUP in OpenOffice Calc on Windows and trying to use a lookup table to populate some other cells.
My Lookup table ranging A1:B6 is
Car 4 Wheels Florida No Bus 8 Wheels Lorry 18 Wheels Michigan Yes Bike 2 Wheels
My cells which I plan to populate using the
VLOOKUP data are at range E1:E6 and I am using the function
Applying this to the following data gives incorrect results
Michigan Yes Lorry 18 Wheels Bike #N/A Car 4 Wheels #N/A Florida No
Bike should return 2 Wheels, but returns #N/A.
Doing some tests I have tried replacing the word Bike with another and sometimes the function gives the expected results other times it doesn't.
This function also seems to return different results depending on which order the words inyour lookup table are and which order you first initially reference them in your "population" cells.
What is the cause of this behaviour? Its very random and is causing me huge problems as I cannot progress and rely on my spreadsheet.