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

I went into a new spreadsheet and took away all the table stuff so it's just raw data:

=VLOOKUP(G2,Sheet2!A1:D450,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

AHHHH I hate when I can't look at the actual spreadsheets. @_@




Ok.

So. I remember why I had to use my INDEX function now. LOL. But I don't you'll need to hear if you can manipulate your data.

In your "2) suburb/region details with two columns" spreadsheet, you need to switch Column A and Column B.

=VLOOKUP(Table1[[#This Row],[Mailing Post Code]],Post,1,FALSE)

Change that to 1 and see if it works?

Actually, I don't think that'll work. I still think you need to switch Column B and Column A in Worksheet 2 and then put the 2 back in for the column count...

check your pm!!!!!!!!!!!!!!!11

Your 2nd field is wrong.

2nd field has to be a box with multiple columns.

huh?

what second field?

Pmed

I have the same problem

In your Postcode suburbs list, is the suburb listed in alphabetical order?

Is your formula in sheet 1?