Match 3 Columns return 4th

[Utradeshow]

Hi Guy's,

I have 2 data sets, Column A-C in Sheet1 and Column A-C in Sheet2. I need to do a VLOOKUP type of formula that if the Data in columns match exactly then it will return the value in column D of that row.

For example SHEET1

Book1.xlsx
	A	B	C	D
1	L	W	H	Volume
2	12	12	24	6
3	24	24	48	12
4	36	36	72	18
Sheet1

And Sheet2

Book1.xlsx
	A	B	C	D
1	L	W	H	Volume
2	36	36	72	18
3	24	24	45	N/A
4	12	12	24	6
Sheet2

Any ideas?

 

[chipsworld]

See if this may help?? Similar issue

cross reference two cells in one sheet against two cells in second sheet - return data from third cell

Hello, Help please. I have myself all confused on how to accomplish the following. Column H2/Sheet1 --- match data in last 4 characters in C2 & all of D2 against data in column B & C in Sheet2 and return the value in column D Column I2/Sheet1 --- match data in I1 & D2 against data in column B &...

www.mrexcel.com

 

[hagia_sofia]

Hello, for example:

=XLOOKUP(1,(Sheet1!$A$2:$A$4=A2)*(Sheet1!$B$2:$B$4=B2)*(Sheet1!$C$2:$C$4=C2),Sheet1!$D$2:$D$4,"N/A")

 

[Utradeshow]

Yes sir! Thank you so much