Forum Discussion
Not looking at the right page column
Hello! EXCEL Version: 2019 MSO 64-bit Purpose: Vendor title list comparison. I am trying to code a summary page that shows a title that is on both datasheets that also pulls the full-text date ran...
In 2019 formula entered in row 8 like
=IF( A8 = sheet!C8:c300, 7, "" )works the same way as
=IF( A8 = sheet!C8, 7, "" )Excel takes entire range from another sheet and from that range the value which is on the same row 8.
You need to use another VLOOKUP or INDEX/MATCH
- Thank you! I will give that a shot.
Amanda
