|
It doesn't work.
I have two spreadsheets:
1) client details (e.g. Postcode in Column A)
2) suburb/region details with two columns: column A - Region, column B - Postcode
I'm trying to find out what region the clients are from by matching their postcode from sheet 1 to the list of postcode/regions in sheet 2.
But my formular looks like this
=VLOOKUP(Table1[[#This Row],[Mailing Post Code]],Post,2,FALSE)
Replaced false with 0 but didn't work either.
Edit: "Post" is the name of sheet 2
__________________
=)
|