Take a look at the Vlookup function. I prefer index/match but Vlookup will
work in a pinch.
--
HTH...

Jim Thomlinson


"conditional format if cell contains word" wrote:

Thank you for reading my post and considering helping me. My name is Matthew
and I work for Border Logistics. My e-mail is

Question:

If sheet 1 is a master list of products that looks like this but much larger:

ITEM NUMBER(A1) DESCRIPTION AVG Wght EST
4263 CHICKEN BREAST 10.0 P-7085
59234 CHICKEN DRUM 10.5 P-72
66850 TURKEY HAM 10 P-210
89222 PEPPERONI SLICED 25.0 13433

Sheet 2 is an order with item codes with a blank description, avg weight,
and EST like this:

Item Code(B7) Description Case Weight EST
143823 (blank) 9 (blank) (blank)
143836 4
143563 2
143875 4
424977 10


Now if the item code on sheet 2 (the order) matches the item code on sheet
1(the master list)

How do I get the description, avg case weight, and EST to fill in
automatically. I understand that this is a lot to ask for, so if anything
then I just need the EST to fill in, my boss said that would be fine for now.
Please help I have an appointment with the USDA and have to have my paperwork
sent off by noon to Canadian Food Inspection Agency. My e-mail is


Thank you in advance,



Matthew Anderson :-)