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.
|