VBA iserror/vlookup

[muss1210]

Hello forum

I have the below code which works but when i get part of a result it wont show a error but will show a 0, how can it be done so that if a error or that it shows a 0 that it will only show a blank cell

Please Login or Register  to view this content.

thanks in advance

[WideBoyDixon]

It's one of the downfalls of both VLOOKUP and INDEX/MATCH so you have to test three times:

Please Login or Register  to view this content.

WBD

[davsth]

or format as a custom format 0;-0;;@

and try
iferror(MATCH(J30,'(Bulk) Helper Sheet'!$A:$A,0),"")

it does assume that 0 is not a legitimate value in the lookup table

[WideBoyDixon]

I thought about that but discarded it because I didn't know for certain that there are *definitely* no legitimate zero values in the table. OP didn't bother to upload a sample workbook

WBD

[WideBoyDixon]

Actually, if the return value is a text field (not numeric) then you could simplify:

Please Login or Register  to view this content.

WBD