Lookup or Match with rows and column together
i would like to look up a value from worksheet2 based on cells matching the
row and column from worksheet1 together...example below
worksheet 1
COLUMM
ROW.. MILK VEGETABLES FRUITS MEATS
salesperson1 ?? ?? ??
??
salesperson2 ?? ?? ??
??
salesperson3 ?? ?? ??
??
salesperson4 ?? ?? ??
??
worksheet2 ( sales report)
ROW 1 ROW2 ROW3
salesperson1 MILK 321
salesperson1 CHOCOLATE 211
salesperson1 MEATS 765
salesperson2 VEGATABLES 90
salesperson2 DONUTS 672
salesperson3 FRUITS 389
salesperson3 SALADS 300
salesperson4 MILK 111
salesperson4 FRUITS 865
--
Listu
|