Originally Posted by Hraesvelg
|
|
I'm disappointed in the Excel HHOOKUP command. Never returns what I want it to.
|
I have the same problem
|
Originally Posted by Blaaaaaaaah
|
I went into a new spreadsheet and took away all the table stuff so it's just raw data:
=VLOOKUP(G2,Sheet2!A1 450,3,FALSE)
Still get #N/A though.
I went to show calculation steps and apparently the error occurs with G2 - locating the postcode in the first place.
waii
|
In your Postcode suburbs list, is the suburb listed in alphabetical order?
Is your formula in sheet 1?
Threaded Mode
