VLOOKUP formula that also can prevent the cell from showing a 0 if the Cell is blank

Hello All,

With the formula below I am doing a VLOOKUP. The issue is that if the cell is blank that the data is being pulled from a 0 is entered

Please Login or Register  to view this content.

Is it possible to build in the IFERROR feature and still do the VLOOKUP?

Thanks

John

=if($M$4="",0,VLOOKUP($M$4,EmployeeData!$A$2:$L$22,12,FALSE))

mehmetcik,

Thank you for your response...

I entered the formula you suggested and it still showing a zero

I think the issue is that M4 is on the sheet that is pulling the data from another sheet (EmployeeData)

If $A$2:$L$22 have no data then that is where the 0 comes in play

John

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Is the formula returning TEXT or a NUMBER?

is this what you are looking for?
=IF(VLOOKUP($M$4,EmployeeData!$A$2:$L$22,12,FALSE)=0,"",VLOOKUP($M$4,EmployeeData!$A$2:$L$22,12,FALSE))

If it is TEXT, use:

=VLOOKUP($M$4,EmployeeData!$A$2:$L$22,12,FALSE)&""

If it is a NUMBER, use:

=IFERROR(1/(1/VLOOKUP($M$4,EmployeeData!$A$2:$L$22,12,FALSE)),"")

You're welcome and thanks for the rep.