I put together this formula:
=IF(ISNA(VLOOKUP(A3,Sheet2!$A$2:$E$100,5,0)),"7",VLOOKUP(A3,Sheet2!$A$2:$E$100,5,0))
If the Referenced cell A3 is blank, I want to have the cell show nothing.
I appreciate any help in editing this formula.
Thanks,
Nick
=IF(ISNA(VLOOKUP(A3,Sheet2!$A$2:$E$100,5,0)),"7",VLOOKUP(A3,Sheet2!$A$2:$E$100,5,0))
If the Referenced cell A3 is blank, I want to have the cell show nothing.
I appreciate any help in editing this formula.
Thanks,
Nick