Vlookup

  • Thread starter Thread starter gordo
  • Start date Start date
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
 
=IF(ISNA(VLOOKUP(A1,[Workbook2.xls]Sheet1!$A:$B,2,FALSE)),"",VLOOKUP(A1,[Workbook2.xls]Sheet1!$A:$B,2,FALSE))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP Problem 1
VLOOKUP 2
=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ", VLOOKUP(A3,con 4
Vlookup or Other vs Sort? 1
Multiple IF Statement 2
VLOOKUP problem 3
Vlookup on blank cells formatted with dates 3
Using COUNTA and excluding formulas that gives zero or blank cells 3

Back
Top