Vlookup
 

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

Vlookup
 

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


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=528823