Hello Excel specialists,
I have two formulas I would like to merge:
First formula
=IFERROR(VLOOKUP($A8,List2!A:T,9,0),"Value not found")
This formula is checking if cell value of A8 exists in List 2
Second formula
=IF(ISBLANK(VLOOKUP($A8,List2!A:T,9,0)),"Empty",VLOOKUP($A8,List2!A:T,9,0))...