If/If Then with Vlookup?

[treym]

I'm thinking I need to do an If/If Then with Vlookup function. I essentially want identify if something is a "unit" or a "case" and return a specified number based on its code. There may be something easier.

Excel 2010
	A	B	C	D	E	F
1	Pack	ID	unit	case
2	unit	1234	12345
3	case	1224		12245
4
5	Desired Output	IF A2 = "unit" then vlookup table and provide new unit number of "12345" in cell C2
6		If A3 = "case" then vlookup table and provide new unit number of "12245" in cell D3
7
8	Lookup Table
9	ID	Unit	Case
10	1234	12345	12245
11
Sheet1

 

[treym]

Ok, I think I figured it out! No need for the help!