vlookup returns N/A

  • Thread starter Thread starter gibson
  • Start date Start date
G

gibson

Hello,

I have a list of the NFL teams in col A. In col B I have a
2 or 3 letter abbrieviation for that team.

I use a simple lookup formula to return that abbrev.

=VLOOKUP(D1,A1:A32,2)

I get the #NA error code in some cells no matter what
configuration I have in col A.

If I have col A sorted ascending and include the TRUE
argument in the formula, I still get NA.

If I have col A not sorted(random) and use the FALSE
argument in the formula, I still get NA.

I would think one or the other should work but neither
does.

I also tried an INDEX MATCH formula but I can't get that
to work at all.

Any suggestions?

Thanks!
 
Thanks for the reply Don.

I found the apparent problem! The list of teams was
copied/pasted from a web site. There must have been some
unseen characters that copied over. I deleted the list and
manually re-entered it and now things are working just
fine.
 
gibson

As written, your formula has only one column in the lookup range.

=VLOOKUP(D1,A1:A32,2)

Change to =VLOOKUP(D1,A1:B32,2)

Gord Dibben Excel MVP
 
Yeah, thanks for the reply. That was my fault. Just a typo
in the post!
-----Original Message-----
gibson

As written, your formula has only one column in the lookup range.

=VLOOKUP(D1,A1:A32,2)

Change to =VLOOKUP(D1,A1:B32,2)

Gord Dibben Excel MVP
Click to expand...
 
Back
Top