I need help with a formula, please. I have two sheets: Sheet 1 is a
purchase order form. Sheet 2 holds the following:

Col A Col B
BG Bag
BX Box
YD Yard
FT Feet

I used Data Validation to create the drop down box in the Purchase Order and
named B1:B4, above, as "Description." The choice would be from
"Description," but the value to be returned should be from Column A (the
abbreviations).

I am using 2003.

Thank you!
--
MB