View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
conditional format if cell contains word[_2_] conditional format if cell contains word[_2_] is offline
external usenet poster
 
Posts: 16
Default IF A CELL ON ONE WORK SHEET MATCHES ANOTHER WORKSHEET

The master looks like this but much larger.
ITEM NUMBER DESCRIPTION AVG Wght EST
4263 CHICKEN BREAST 10.0 P-7085
59234 CHICKEN DRUM 10.5 P-72
66850 TURKEY HAM 10.0 P-210
89222 SLICED BONELESS 25.0 13433

The order looks like this:
Item code Description Cases total
weight EST
143823 9
143836 10
143563 5
143875 6


ID CERT_DESC CASES total WEIGHT EST
143823 BEEF CHUCK EYE ROLL 9 585 86E
143836 BEEF FEET USDA 4 16 562M
143563 BEEF FLANK STEAK 2 130 86E


So I need the descriptions and ESTs to be filled in with exact matches and
need the weight to be the avg weight from the master multiplied by the cases
from the order.