=IF(ISERROR(VLOOKUP(E6&"-"&F6,Table!A:L,7,FALSE)),"",VLOOKUP(E6&"-"&F6,Table!A:L,7,FALSE))



"xlmate" wrote:

would you show your formula

--
Hope this is helpful

Appreciate that you provide your feedback by clicking the Yes button below
if this post have helped you.


Thank You

cheers, francis










"FP Novice" wrote:

I am using some lookup functions in multiple cells of a spreadsheet.
Depending on the search a cell may actually have a null value. When a null
value is returned the cell is populated with a '0'. My question is how do I
make it so a null value is simply an empty cell?

Thank you,
Todd