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
cowboywmAsked:
Who is Participating?
 
Wayne Taylor (webtubbs)Connect With a Mentor Commented:
You can use this formula as copy down as required.

="Communications: " & VLOOKUP(B2, Sheet2!B:AC, 26, FALSE) & CHAR(10) & "Learning: " & VLOOKUP(B2, Sheet2!B:AC, 27, FALSE) & CHAR(10) & "Procedures: " & VLOOKUP(B2, Sheet2!B:AC, 28, FALSE)

Open in new window


You will also need to enable Wrap Text on those cells for each item to display on a new line.
1
 
cowboywmAuthor Commented:
Perfecto!  Did exactly what I needed it to do.  I knew there was a way but wasn't sure just how to build it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.