Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
222
Views
Topic starter
Hello!
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?
Posted : 28/01/2023 10:40 am
Hi,
You can use Power Query to compare two tables and return matching results as explained here: Easily compare multiple tables in Power Query
Mynda
Posted : 28/01/2023 6:38 pm
