January 28, 2023
I'm looking for a way to do the following:
-Compare a pair of cells on sheet A to another pair of cells on sheet B.
-If the pairs match (only one match will be possible), return the value from the column on sheet B corresponding to that matched pair.
Can somebody help me?
July 16, 2010
You can use Power Query to compare two tables and return matching results as explained here: Easily compare multiple tables in Power Query