complicate chemical inventory drop down reference.

**russader** · 02-17-2013, 02:02 PM

I am stuck with an odd one.
I'm running excel 2010.
I have all the chemicals in my warehouse in column A A2:A120.
I have each chemicals corrisponding LOT #s in E column ED2:E120.
If we are temporarily out of a chemical we obviously don't ave a lot #.
Lot #s are a series of alpha numerics.
I'm trying to make a seperate list starting at A121 which is a repeat of all chemicals listed above which have lot #s associated with them.

So if A2 is CaCl2 and we have it in hand E2 will have the Lot filled out and A121 will also say CaCl2.

A2 may say Calcium hydroxide but we are out so we delete it's lot. A3 may say Liquid nitrogen which we have on hand and so it does have a lot # in E3.

So A121 says CaCl2 and A122 says liquid nitrogen.

Any help would be appreciated.