Vlookup help

Sam666666

Board Regular
Joined
May 5, 2015
Messages
105
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
Joined
May 5, 2015
Messages
105

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
Joined
Feb 5, 2010
Messages
2,350
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
Joined
May 5, 2015
Messages
105

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
Joined
May 5, 2015
Messages
105
Thanks for the formula before. The formula should be in sheet 2. Are you able to edit this?
 
Master Excel Bundle

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.

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top