L
lehigh46
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
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