Compair two pair of cells: function usage

[and_woox]

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?

 

[Fluff]

Hi & welcome to MrExcel.
What columns are the data in on sheet B?

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Compair two pair of cells: function usage
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[awoohaw]

DOES THIS WORK:

WorkBook1.xlsx
	A	B	C	D	E	F	G	H
1
2
3	START	END				START	END
4	12	36	AMANDA			56	23	LISA
5	23	45	SANDRA			23	45	SANDRA
6	56	23	LISA			12	36	AMANDA
7
Sheet2

Cell Formulas
Range	Formula
C4:C6	C4	=INDEX($H$4:$H$6,MATCH(A4&B4,$F$4:$F$6&$G$4:$G$6,0))

 

[and_woox]

Thanks for the reply, unfortunately it didn't work.
I uploaded the original file.

easyupload.io

easyupload.io

easyupload.io

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?

 

[awoohaw]

I don't download random data, i'm sorry.
Please post a 30-40 rows with your desired results/problems with the xl2bb add in?

 

[RoryA]

Perhaps you missed this part of Fluff's post:

if you have posted the question at other places, please provide links to those as well.

Please comply with the request.