Please help...I am at work and have a 3pm PST deadline...

[conditional format if cell contains word]

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

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
(e-mail address removed)

Thank you in advance,



Matthew Anderson

 

[Jim Thomlinson]

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

 

[Don Guillett]

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
(e-mail address removed)
"conditional format if cell contains word"

 

[conditional format if cell contains word]

Sorry jim, I messed around with that earlier and I am not aware of how to
write teh code. Thank you though.

 

[Andy_N1708 via OfficeKB.com]

Assuming Itemcode in B7, matches with Itemnumber in A1 (Master list) you can
use a VLOOUP to fill in the information for the rest of the order sheet.

 

[conditional format if cell contains word]

Thank you I have tried that, but I cannot get it to work. I am new to going
this advanced into Excel and cannot get it to work. Thank you though

 

[conditional format if cell contains word]

What do I put in range look up?

Assuming Itemcode in B7, matches with Itemnumber in A1 (Master list) you can
use a VLOOUP to fill in the information for the rest of the order sheet.

 

[Andy_N1708 via OfficeKB.com]

Matt,

Range look up should be FALSE

What do I put in range look up?

Assuming Itemcode in B7, matches with Itemnumber in A1 (Master list) you can
use a VLOOUP to fill in the information for the rest of the order sheet.

[quoted text clipped - 35 lines]

 

[conditional format if cell contains word]

Thank you, I got it to work, but now the col_index_number keeps changing on
me when I try to copy the formula down...do you know what I am doing wrong?

If its easier please e-mail me at (e-mail address removed)

Matt,

Range look up should be FALSE

What do I put in range look up?

Assuming Itemcode in B7, matches with Itemnumber in A1 (Master list) you can
use a VLOOUP to fill in the information for the rest of the order sheet.

[quoted text clipped - 35 lines]

Matthew Anderson

 

[Don Guillett]

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)

 

[Andy_N1708 via OfficeKB.com]

Matt,

What is your formula? The col_index_num should not change.

Thank you, I got it to work, but now the col_index_number keeps changing on
me when I try to copy the formula down...do you know what I am doing wrong?

If its easier please e-mail me at (e-mail address removed)

Matt,

[quoted text clipped - 7 lines]