View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Listu Listu is offline
external usenet poster
 
Posts: 4
Default 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