Possible IF and Multiple VLookup?

[treym]

I have 3 different identifiers: Unit #, Pack # and Case #. I normally use a vlookup up on the case # to a table that returns an respective item #. I don't have item # for Unit and Pack. I'd like to say if Unit #, Pack # or Case # match in the other table, return the same Item # to all three. How would I go about doing that?

Excel 2010
	A	B	C	D	E
1	Main Table
2	Name	Unit #	Pack #	Case #	Item #
3	Product A	11	22	33
4
5	Reference Table
6	Name	Unit #	Pack #	Case #	Item #
7	Product A	11	22	33	100
Sheet1

Cell Formulas
Range	Formula
A1	Main Table
A2	Name
A3	Product A
A5	Reference Table
A6	Name
A7	Product A
B2	Unit #
B3	11
B6	Unit #
B7	11
C2	Pack #
C3	22
C6	Pack #
C7	22
D2	Case #
D3	33
D6	Case #
D7	33
E2	Item #
E6	Item #
E7	100