William C Johnson
asked on
VLOOKUP Function MS Excel 2010
I would like to create a formula in Sheet1, cell C2, that will use the VLOOKUP function to pull data from Sheet2 and append it to some standard text within the same formula. The format of all the data should be vertical, each category on its own line within the same cell. See sample file attached.
Communications: Mary Smith
Learning: John Jones
Procedures: None Requested
Is it possible to do this?
Thanks,
Test---VLOOKUP.xlsm
Communications: Mary Smith
Learning: John Jones
Procedures: None Requested
Is it possible to do this?
Thanks,
Test---VLOOKUP.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER