How do get the LOOKUP function to not read empty cells as zeros
Maybe
=IF(ISBLANK(A1),"",LOOKUP(A1,{0,1},{1,0}))
Mike
"LGriffin" wrote:
I am trying to reverse code 0s and 1s with =LOOKUP (reference cell,
{0,1},{1,0}). When the reference cell is empty, I'd like the function to
also return an empty cell.
|