Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

To extract data from multiple cells matching to a unique number

0
Batch # Item Name Result Needed 2017-63 Mango Mango, Carrot 2017-64 Orange Orange, Beans 2017-292 Apple Apple, Peas 2017-63 Carrot Mango, Carrot 2017-64 Beans Orange, Beans 2017-292 Peas Apple, Peas

I need help to get the result as above using Formula in Excel

Answer
Discuss

Answers

0

Look up the VLOOKUP function in Excel help. It will help you find any data from a row which has an identifier. For example, if you know the number "2017-63" you can find the description "Mango". Normally, all of that wouldn't be on the same tab, however, at least not in the same table.
I think if you use Excel Help you will probably find all the guidance you need. You might also google for VLOOKUP and find examples. But if you need more help than that post a copy of your workbook and we shall design a formula for you that you can use right away.

Discuss

Discussion

VLookup can bring only one text.. I need to combine multiple text pertained to one specific value.. 
Christo22 Oct 25, '17 at 6:25 am
There is no function to read more than one cell at a time but the results of multiple Vlookups can be combined into one cell.
Variatus (rep: 4889) Oct 25, '17 at 6:36 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login