Excel Index Formula - Page 2

**Blaaaaaaaah** · 07-08-2011, 02:29 AM

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

**Blaaaaaaaah** · 07-08-2011, 02:34 AM

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

**Ralath** · 07-08-2011, 02:38 AM

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?

**Ralath** · 07-08-2011, 02:42 AM

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

**Ralath** · 07-08-2011, 02:46 AM

**Blaaaaaaaah** · 07-08-2011, 02:51 AM

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

**Ralath** · 07-08-2011, 02:56 AM

Your 2nd field is wrong.

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

**Blaaaaaaaah** · 07-08-2011, 02:58 AM

huh?

what second field?

**Ralath** · 07-08-2011, 02:58 AM

**Hessah** · 07-08-2011, 02:59 AM

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?