excel vlookup only returning last row and index not working

[maynote]

It is frustrating i have been looking at this for 45 minutes.

I want to basically reference a table i have in excel, but when i use the Vlookup, only the last cell is pulled oned and sometimes an "N/A" error. I tried index as well since it might suit my needs better. Still does not work. I must be entering my formulae incorrectly. Here they are:

=INDEX($B$44:$B$64,MATCH(AP12,$C$44:$C$64,0))
=VLOOKUP(AP7,$B$44:$C$64,2,FALSE)

the table is in cells b44:c64. the titles for the table are in b43,c43. The cell i am trying to reference is AP12 and the formula is typed into AQ12.

What have i done incorrectly?

Thanks for your time

 

[sheetspread]

Did you enter the data or download it from somewhere? Try copying AP7 to wherever in B44:B64 it's supposed to be (or vice versa) to see if there are any format differences which can jam the vlookup.

 

[maynote]

Did you enter the data or download it from somewhere? Try copying AP7 to wherever in B44:B64 it's supposed to be (or vice versa) to see if there are any format differences which can jam the vlookup.

i did not copy it from anywhere. i wrote it out myself. i cant spot a format difference, but as you know most of the time we all overlook the simplest thing.

 

[PaddyD]

Often, these sorts of issues come not from format differences but from data type differences where, e.g. a number is held as a text value.

If that might be it you can check with:

=isnumber(a1)

...for your data and see if it returns what you expect.

 

[barry houdini]

=INDEX($B$44:$B$64,MATCH(AP12,$C$44:$C$64,0))
=VLOOKUP(AP7,$B$44:$C$64,2,FALSE)

These formulas do different things, the first one looks up the lookup value in C44:C64 and returns a result from B44:B64, the second one reverses that

Which one should it be?

 

[sheetspread]

You can also account for the different lookup cells: AP7 and AP12, right?