Thread
:
How do get the LOOKUP function to not read empty cells as zeros
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
LGriffin
external usenet poster
Posts: 1
How do get the LOOKUP function to not read empty cells as zeros
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.
Reply With Quote
LGriffin
View Public Profile
Find all posts by LGriffin