Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Lookups in one Cell
Hi All
On spread sheet named "work list", column A has numbers 1 thru 100 Column B contains a list of corrosponding work types. ie; 1 CLEARING 2 EXCAVATION 3 PAVING 4 DRAINAGE On another worksheet named "contractors", column A contains the number of the work type that they perform. Column B contains the company name. Some contractor's may perform more than one type of work. Therefore column B may have more than one work type. My question is, what lookup formula can I use in column C to look back at "work list" and show multiple work descritions in column C on the "contractors" worksheet? For example COL A COL B COL C 1, 2 XYZ COMPANY CLEARING, EXCAVATION 3, 4, 2 ABC ENTERPRISES PAVING, DRAINAGE, EXCAVATION thanks for any help you can give me |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum multiple lookups? | Excel Worksheet Functions | |||
multiple column lookups | Excel Worksheet Functions | |||
multiple column lookups | Excel Worksheet Functions | |||
Multiple V Lookups | Excel Worksheet Functions | |||
Multiple Lookups | Excel Discussion (Misc queries) |