| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| match, lookup two column data | Excel Worksheet Functions | |||
| Lookup where column data does not match | Excel Worksheet Functions | |||
| Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
| Need rows in Column A removed if they fully or partially match with any Column B row | Excel Discussion (Misc queries) | |||
| Copy Rows if Lookup Criteria Match | Excel Discussion (Misc queries) | |||
Threaded Mode
