VLOOKUP with an IF

[Draccusfly]

Hi

I am trying to tidy up a worksheet that has a vlookup reference to a second worksheet. The formula at present is:

=VLOOKUP($J:$J,'DATA ENTRY'!$A$3:$H$1000,3,FALSE)

The primary sheet has a data connection on columns J:X which updates on a daily basis, reference data is then placed on the data entry sheet which then populates data back to the primary sheet on columns A:I based on the result of the lookup. As data is removed or changed in columns J:X columns A:I will update and line up across columns A:X

What I want to do is try and use an IF statement so that if the resultant value of the lookup is 0, #N/A or 00-Jan then nothing should be displayed in that cell.

at this stage the workbook works fine just looks abit untidy

Drac

 

[jasonb75]

There is a cell reference missing.

=IF(ISBLANK(VLOOKUP(B3,'New Starter Monitor & Spot'!$B$79:$N$88,3,FALSE)),"",VLOOKUP(B3,'New Starter Monitor & Spot'!$B$79:$N$88,3,FALSE))

 

[bennobes]

What an absolute idiot!!!!!!! Thank you. First time I have ever used a forum...how embarassing.