Thread
:
Please help...I am at work and have a 3pm PST deadline...
View Single Post
#
4
Posted to microsoft.public.excel.misc
conditional format if cell contains word[_2_]
external usenet poster
Posts: 16
Please help...I am at work and have a 3pm PST deadline...
Sorry jim, I messed around with that earlier and I am not aware of how to
write teh code. Thank you though.
"Jim Thomlinson" wrote:
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 :-)
Reply With Quote
conditional format if cell contains word[_2_]
View Public Profile
Find all posts by conditional format if cell contains word[_2_]