Vlookup help

[Sam666666]

Hi,

I want a formula which tells me the following:

If column A in sheet 1 matches column B in sheet 2 and Column D in sheet 1 matches column A in sheet to come back as agreed if not then disagreed.

Excel 2012
	A	B
2	Type	Product name
3	50	Desk
Sheet2

 

[Sam666666]

Excel 2012
	A	B	C	D
1	Product name	Description	Amount	Type
2	Desk	Blue	100	50
3	DVD	Red	100	60
4	Table	Yellow	200	70
Sheet1

Excel 2012
	A	B
2	Type	Product name
3	50	Desk
4	60	DVD
5	70	Table
6	10	Desk
7	20	DVD
8	30	Table
Sheet2

 

[bbott]

In Sheet1 as an array formula (CTRL+SHIFT+ENTER, not just Enter):

=IF(ISNUMBER(MATCH(A2&D2,Sheet2!$B$2:$B$7&Sheet2!$A$2:$A$7,0)),"Agree","Disagree")

Excel will surround the array formula with {} when entered correctly.

 

[Sam666666]

Is this possible?

 

[Sam666666]

Excel 2012
	A	B	C	D	E
1
2	Price	Product 1	Product 2	Product 3	Product 4
3	50	table	table	chairs	Door
4	60	chairs	chairs	lamp	lamp
5	70	lamp	lamp	chairs	chairs
6	20	chairs	Flowers	Flowers	Flowers
Sheet 1

Excel 2012
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2	Product name	amount	Price high	Price low
3	table	500	60	50
4	chairs	400	30	20
5	lamp	200	40	10
6
7
8	If A is sheet 1 is between D and C in sheet 2 and B, C,D and E in sheet 1 matches column A in sheet 2. If matches come back as agreed in column E if not disagree.
Sheet2

 

[Sam666666]

Thanks for the formula before. The formula should be in sheet 2. Are you able to edit this?