View Single Post
 
Old 10-23-2022, 05:23 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

It depends what you're trying to do.
It looks as though you're comparing 2 columns in each table to find matches:
A formula at cell G2 (copied down) does this and that may be all you need.
Code:
=XLOOKUP($B2 & "¬" & $E2,All!$B$2:$B$2835 & "¬" & All!$E$2:$E$2835,All!$A$2:$E$2835,"Not found")
However, you may have a problem; there may be more than one row in the All sheet that matches the two columns in the Data sheet. I've highlighted which rows this applies to in column N where if there's a value >1 there are multiple matches. In a few instance I've shown those matches in column O at rows 28, 34 and 512 (where there are 3 matches).
So are you looking to return only complete matches, or maybe on more than 2 columns?


Edit: I've just noticed you're using Office 2016 so some of the functions I've used may not work, although the results of those formulae should still show. Tell me if the G2 formula fails and I'll re-write.
Attached Files
File Type: xlsx msofficeforums49833Test.xlsx (197.3 KB, 5 views)
Reply With Quote