Forum Discussion
Solved
Excel IF Statement not working
I have a workbook with 2 worksheets. I want the IF statement to look at the second worksheet and if a certain number is in the list to return a yes, if not a no. what I have is: =IF('Direct-Bills-...
Hi Conchita,
Please try this formula instead:
=IF(ISNUMBER(MATCH(B6,'Direct-Bills-4-16-17'!A:A,0)), "Yes", "No")
I hope this helps you
Haytham
Hi Conchita,
It depends on how your data is structured. If that formula is in row 6, column A of first sheet, it takes from exactly the same row 6 if the second sheet and compares with B6. If you drag that formula down it takes values in rows 7 and compares with B7.
Is that your scenario?
Thank you for working on this for me. No, that was not the issue. See the reply from Haytham Amairah above. His formula worked for my problem. Again, thank you.
Connie
Again, in general it depends on how your data is structured. In particular, you have no repeated values in second sheet.
Anyway, so far so good if works.
