[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 79
  • Last Modified:

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
0
cowboywm
Asked:
cowboywm
1 Solution
 
Wayne Taylor (webtubbs)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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now