Thread: How do get the LOOKUP function to not read empty cells as zeros
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
  
Posts: 3,346
Default How do get the LOOKUP function to not read empty cells as zeros
Hi,

why are you using lookup?

=IF(A1=0,1,IF(A1=1,0,""))


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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.
Reply With QuoteReply With Quote