Forum Discussion
Comparing two columns in two different excel spreadsheets
I am trying to compare columns from two different sheets in two columns that matches to get a value from a 3rd column on the first sheet. Example, Sheet 1 has Column D and E and I want to search Sheet 2 in columns F, G and H. D and E from sheet 1 must match the Row for F and G in sheet 2. If they match then I need the number that is in H for that same Row. Can I get some help on what to use, a formula or a function?
Thank you
1 Reply
=INDEX(Sheet2!$H$1:$H$25,MATCH(Sheet1!D1&Sheet1!E1,(Sheet2!$F$1:$F$25&Sheet2!$G$1:$G$25),0))Maybe like in the attached file.
