Vlookup

G

gordo

Hi,
Can someone please help me, i am using vlookup to look at values
withing another workbook but is the cell is blank i do not want vlookup
to return the value of N/A.
I want it to return an empty cell or blank cell



Thanks

Gordon
 
C

CaptainQuattro

=IF(ISNA(VLOOKUP(A1,[Workbook2.xls]Sheet1!$A:$B,2,FALSE)),"",VLOOKUP(A1,[Workbook2.xls]Sheet1!$A:$B,2,FALSE))
 
Top