OP sent file and I solved with vlookup formulas.
=IF(ISNA(VLOOKUP($B2,'Master List'!$A$2:$D$76,2,0)),"",
VLOOKUP($B2,'Master List'!$A$2:$D$76,3,0)*D2)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
I don't see a before/after example. If desired, send your file to my
address below with this msg and a CLEAR explanation of what you need.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"conditional format if cell contains word"
icrosoft.com wrote in
message ...
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 :-)