Find value based on two values entered

[rogator]

Hello,
I have a table of data on a worksheet labeled Information. The table has three columns, Y2:Y29 is employee names, Z2:Z29 is equipment and AA2:AA29 is code number (six digits). On another worksheet labeled Form I have validation lists in cells C26 and C28. C26 is the employee name validation list and C28 is the equipment list. I would like to have the code number from Information sheet placed in cell C30 when the employee name and equipment used is selected. Also cells C26, C28, and C30 are merged, don't know if that is causing problems with some of the formulas I have tried or not.
Any help would be greatly appreciated, Thanks.

 

[Brian from Maui]

If employee names and equipment produce a unique identifier, one example of Index/Match

Book1
	A	B	C	D	E	F
1	Name	Equip	Code	222222
2	a	tt	111111	222222	b	yy
3	b	yy	222222
4	c	uu	333333
5	d	oo	444444
6	e	pp	555555
Sheet1

 

[BruceyBonu$]

Merged cells should not matter

Enter formula with Ctrl+Shift+Enter in C30

=INDEX(information!y2:aa29,MATCH(Form!y26&"@"&c28,y2:y29&"@"&z2:z29,0),3)

 

[BruceyBonu$]

=INDEX(information!Y2:AA29,MATCH(Form!C26&"@"&Form!C28,information!Y2:Y29&"@"&info!AA2:AA29,0),3)

sorry slight type in last effort, this should work.. dont forget the Ctrl shift Enter

 

[rogator]

Thank You very much! It works great now!