Forum Discussion
daemonlibrarian
May 24, 2023Copper Contributor
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...
SergeiBaklan
May 24, 2023Diamond Contributor
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
- daemonlibrarianMay 25, 2023Copper ContributorThank you! I will give that a shot.
Amanda