Reply With Quote
1. The table you are looking-up is a very small table with only one row on the customers spreadsheet!!
2. The formula you have used is looking for the string maitland&nsw&2320 (or in fact the nearest match - since you have specifed the fourth parameter as true) in the F column (the leftmost one in the table); (specifically in cell F8 since there is only one row in your table).
3. If you wanted to string-together (or concatenate) the elements maitland nsw and 2320, the correct syntax would be "maitland"&"nsw"&"2320"
4. As long as the inverted commas have been set correctly, then the value of G8 (since the G column is column 2 in your table) should be returned as the result, since this is the only possible value in the one-rowed table.
EDIT
I think I now see what you are trying to do - that is if the three columns in customers are suburb, state and postcode.
To use vlookup you would need a fourth column to the left of these three, containing some references such as customer names, etc.
You would then need to concatenate three separate vlookups to return the three results as a string, viz:-
=VLOOKUP("RefName",customers!E8:H20,2)&", "&VLOOKUP("RefName",customers!E8:H20,3)&", "&VLOOKUP("RefName",customers!E8:H20,4)&"."
Each vlookup would look for the RefName in the e column and return the values for columns 2,3&4 or f,g&h or suburb,state&postcode.
Also included in the formula is some punctuation so that for a value in column E called RefName, you should get the result:- maitland, nsw, 2320. assuming these are the values for RefName in that row of the table.
