Apr 18 2018
09:22 AM
- last edited on
Jul 25 2018
11:44 AM
by
TechCommunityAP
Apr 18 2018
09:22 AM
- last edited on
Jul 25 2018
11:44 AM
by
TechCommunityAP
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-4-16-17'!A:A=B6, "Yes", "No")
Am I using the wrong function? It seems to work for 192 rows then just puts no in every cell, even if it should be yes.
Really appreciate any ideas/help anyone can give me.
Thank you,
Connie
Apr 18 2018 09:48 AM
SolutionHi 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
Apr 18 2018 09:52 AM
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?
Apr 18 2018 10:58 AM
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
Apr 18 2018 11:16 AM
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.
Mar 05 2021 11:25 AM
Apr 18 2018 09:48 AM
SolutionHi 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