Ok, lets say on sheet 2 I have an inventory list. Colum1 has product name,
Colum 2 has Order #, and colum 3 has on hand qty. Now what I want to do is in
sheet 1 be able to type a product name, and have it return to me the order #,
and On hand qty. I know about ctrl-F, i dont want that. I want excel to
return the info to sheet 1. Any suggestions???