vlookup returns N/A

[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!

 

[Don Guillett]

false is ,false or ,0

 

[gibson]

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.

 

[Gord Dibben]

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

 

[gibson]

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