# Vlookup help

#### Sam666666

##### Board Regular
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
AB
2TypeProduct name
350Desk
Sheet2

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

#### Sam666666

##### Board Regular

Excel 2012
ABCD
1Product nameDescriptionAmountType
2DeskBlue10050
3DVDRed10060
4TableYellow20070
Sheet1

Excel 2012
AB
2TypeProduct name
350Desk
460DVD
570Table
610Desk
720DVD
830Table
Sheet2

#### bbott

##### Well-known Member
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

##### Board Regular
Is this possible?

#### Sam666666

##### Board Regular

Excel 2012
ABCDE
1
2PriceProduct 1Product 2Product 3Product 4
350tabletablechairsDoor
460chairschairslamplamp
570lamplampchairschairs
620chairsFlowersFlowersFlowers
Sheet 1

Excel 2012
ABCDEFGHIJKLM
1
2Product nameamountPrice highPrice low
3table5006050
4chairs4003020
5lamp2004010
6
7
8If 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

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

Replies
7
Views
148
Replies
4
Views
107
Replies
3
Views
116
Replies
9
Views
226
Replies
3
Views
92

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,558
Messages
5,832,455
Members
430,136
Latest member
Asir Jefferson

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back