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,
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
Thank you so very much! It worked perfect!