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

[JJAngel]

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

[mehmetcik]

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

[JJAngel]

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

[mehmetcik]

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.

[JJAngel]

mehmetcik,

Very well... I will put that together!!

Thanks again,

John

[Glenn Kennedy]

Is the formula returning TEXT or a NUMBER?

[Sam Capricci]

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))

[Glenn Kennedy]

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)),"")

[JJAngel]

Sambo & Glenn,

You both have it right... It is Text and tested both of your solutions and the both wor…

Thanks so much!!!

John

[Glenn Kennedy]

You're welcome and thanks for the rep.