Thread: If with AND - Is this correct?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Greg Greg is offline
external usenet poster
  
Posts: 331
Default If with AND - Is this correct?
What is wrong with this formula?

=IF(AND('Node 01'!A1:A1000=A22,'Node 01'!B1:B1000=B22),'Node 01'!H1:H1000,0)

Looking at "A" and "B" for a match and the anwser is "H" the same row as "A&B"
Reply With QuoteReply With Quote