I few problems...
1. You have some trailing spaces in column A of Sheet1. Remove them.
2. Your lookup range starts at row 4, but should include row 3 too.
3. If you want to lookup multiple columns to return row number and you want to use MATCH, you need to do one at a time.
e.g. =IFERROR(MATCH(A2,Sheet2!$I$2:$I$20,0),MATCH(A2,Sheet2!$J$2:$J$20,0))
copied down.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Yes, it was the trailing spaces that ended up being the issue. I had them for my list of 32 teams and then on my list of 250+ games, and since they matched I thought they should work. However, they didn't but did once I removed the spaces from my list of 32 and edited the formulas that generated the matching list, if that makes sense.
Everything works how. Thanks and happy holidays!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks