VLOOKUP help

[John]

I can't get =VLOOKUP(A5,MonthTable,4,FALSE) to show anything but #N/A.
This vlookup fcn is on Sheet1 in cell R5.
Sheet1 cell A5 contains integer 9002
MonthTable is range Sheet2!$A$17:$D$18, the following 2x4 table:
Col A B C D
Row 17 9004 Plate - 599.84
18 9002 Pledge - 14,390.00
I want it to return 14,390.00.

I appreciate your help, -John

 

[xlm]

I don't see anything wrong with your formula.
Is your MonthTable defined as the Name range? if not, it will not work
you can either set up the MonthTable as Name range or
use this
=VLOOKUP(A5,Sheet2!$A$17:$D$18,4,FALSE)

In addition, check to make sure that Col A on both sheets are real numbers,
use ISNUMBER
this will return TRUE if data is a number, and that there're no leading and
trailing spaces, use LEN
this will shows you the number of characters in a cell inculding spaces.

Let me know its work out for you.

--
HTH

Pls provide your feedback by clicking the Yes button below if this posting
is helpful
This will help others to search the results in the archive better
pls click on the Yes button below if this posting is helpful

 

[Chris Bode]

Well, the function seems correct. But if the - 599.84 are in the sam
cell then in will not show the result. Further if the lookup value
blank then it will return #n/a.


Chris