Vlook Up Error

[rnunez8996]

Hi,

I am trying to get the result of a vlookup in sheet 2 named IASA, in sheet 1 JE_Blank I will be entering a search number which will return the value from the table in sheet 2 column 4 but I keep getting a NA. Please help the function I am using is below.

=VLOOKUP("[JEBLANK.xls]JE_BLANK!$A$1:$A31",IASA!$A$2:$B$29,4,FALSE)


Thanks
RNunez

[Ron Coderre]

Here's what you posted:
=VLOOKUP("[JEBLANK.xls]JE_BLANK!$A$1:$A31",IASA!$A$2:$B$29,4,FALSE)

Try this:
=VLOOKUP(a1,IASA!$A$2:$B$29,4,FALSE)
Where the formula is on the JE_Blank sheet and trying to find the value in A1 in the list on the IASA sheet.

Does that help?

Ron