0s. blanks and NA with VLookup

[Kyle123]

I've tried about a dozen if statements to make this work and I've given up.

=IFERROR(VLOOKUP([@SUPKey],'[Inactive Transport  EA Changes  New Price Plans (2).xlsb] over 6 months inactive'!$A:$C,3,FALSE),"")  

For the above, If the value is found but the cell is blank, I want blank
For the above, If the value is found and the cell value is 0, I want 0
For the above, If the value is found and the cell value is anything else, I want anything else
If it isn't found I want ""

The solution I'm sure is ludicrously simple, but my brain is fried. Can someone please put me out of my misery

[martindwilson]

=iferror(IF(VLOOKUP(B1,$E$1:$F$10,2,FALSE)="","",VLOOKUP(B1,$E$1:$F$10,2,FALSE)),"") should work

[Kyle123]

Ta muchly

[benishiryo]

hi Kyle. not very confident without the data, but probably something like that:

Please Login or Register  to view this content.

to counter errors:

Please Login or Register  to view this content.

[Kyle123]

Thanks all working