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?

Attached Images

exemple.jpg (33.7 KB, 11 views)

Try =INDEX(Sheet11!$C$1:$C$3,MATCH(Sheet10!A1&Sheet10! B1,Sheet11!$A$1:$A$3&Sheet11!$B$1:$B$3,0))
Sheet11 is your sheet B and sheet10 is your sheet A

Thanks for the reply, unfortunately it didn't work.
I uploaded the original file.
What I'm trying to do is:

-In sheet REDE COLETORA DE ESGOTO match the pair of cells on column B and C with the corresponding pair in sheet APOIO.
-In sheet REDE COLETORA DE ESGOTO column D return the value from sheet APOIO column D that corresponds to the matched pair.

Can anyone give it a go on the original spreadsheet?

Attached Files

REDE COLETORA DE ESGOTO2.xlsx (242.9 KB, 2 views)

Cross-posts:
Compair two pair of cells: function usage | Chandoo.org Excel Forums - Become Awesome in Excel
Compair two pair of cells: function usage | MrExcel Message Board
https://www.excelforum.com/excel-for...ion-usage.html

Remove the @ in front of APOIO. Must get rid of merged cells. Formula works for row 13 but will not copy down because of merged cells.

Also cross posted at Compair two pair of cells: function usage - Microsoft Community Hub
and Compair two pair of cells: function usage | General Excel Questions & Answers | Excel Forum | My Online Training Hub

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post