Blank cell error
Good morning everyone.
my cell formula is in cell D2 which is; lookup(C2,A2:B32)
when C2 is blank an error (red Triangle) appears in D2
how do I resolve this error?
Cheers
iMac 24″, macOS 15.0
It will give an error if it cannot find a match. It will not find a match for a blank cell.
You can use XLOOKUP which allows you to provide a value (or the null string "") when a match is not found. Or you can put the IFERROR function around your current formula, but that would be silly. LOOKUP is an old function. XLOOKUP is much better.