vlookup error

M

Maggie

I have a vlookup formula that is =vlookup(g13,loan,2) but it is not
working. What am I doing wrong? I have named the reference loan.
But once I put a name in g13 it should look up the loan number that
matches the name. Please help.

Maggie
 
G

Gord Dibben

"Not working" means what?

No results? Incorrect results? Error message?


Gord Dibben MS Excel MVP
 
V

Vergel Adriano

Try this:

=vlookup(g13,loan,2, FALSE)

There is a fourth parameter to the VLOOKUP function. If it's TRUE or
omitted, an approximate match is returned. Also, your table_array must be
sorted in ascending order. If you want it to find an exact match, set the
fourth parameter to FALSE. If an exact match is not found, it will return
#N/A. Find VLOOKUP in Excel Help for more details.
 
Top