Hi Everyone
I have the following formula and would like to add to it but I'm not sure where to create the additional argument:
=IF(ISNA(VLOOKUP($A6,Sheet5!$A$3:Sheet5!$E$389,2,FALSE)),"-",VLOOKUP($A6,Sheet5!$A$3:$E$389,2,FALSE))
Where the ISNA is false, it currently returns a zero value regardless that the cell it's copying from is blank - I would like this to show as "-" rather than a zero. I'm sure this must be possible, as I've used ISBLANK previously, I just don't know where to insert it into my formula.
Thanks in advance for any help.
Jan
Bookmarks