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
I was curious if anyone has an if statement that can time stamp? Currently I am using =IF(A2<>"", NOW(), "") however, when I update cell B2 or C2 it will still change the time in the cell with the formula. Office 365 issue?