Apr 18 2018
- last edited on
Jul 25 2018
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.
Apr 18 2018 09:52 AM
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 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