|
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?
|