Blank to appear

[ekhawaja]

Hello,

I have this formula, i would like to get "blank" cell if value is found to be "0".

Also, would like a second formula to return "blank" if either "0" or #N/A errors occur.

By blank, i mean no value shown in cell, just blank,

=INDEX([book2!$W:$W,MATCH($AJ5,[book2!$E:$E,0))

Thanks in advance.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[ekhawaja]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Version 2306

 

[ekhawaja]

Version 2306

365

 

[Fluff]

Thanks for that
How about

=LET(x,XLOOKUP($AJ5,book2!$E:$E,book2!$W:$W,""),IF(x="","",x))

 

[ekhawaja]

This one works, thanks so much @Fluff

 

[Fluff]

You're welcome & thanks for the feedback.