Excel Lookup Series #3: VLOOKUP Function 3rd Example

[cvnikita1]

dude you rock thanks!

[CapitalinoDF18]

Is it possible for a VLOOKUP to return results as a text string?

In other words instead returning just one value, can it return multiple values separated by commas?

[ExcelIsFun]

@CapitalinoDF18 , I have videos on returning multiple items or records to individual cells, but not a text string. Videos:

Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula

Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula

Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup

For text string ask question at this site:

Mrexcel [dot] com/forum

[akkas013]

Many thanks for your hard work. You r a star...Thanks again..keep it up.

[john22112]

This guys school boy enthusiasm is killing me lol

[andre1onate]

@john22112 Yeah I know....after I learn from him...I'm gonna punch em... lol

[zameerabbinmpl]

wow it's awesome.......... and the way you are teaching make me to learn with fun. you are great dear. Masha Allah!

[ExcelIsFun]

I am glad that the videos help!

[GigiLauren22]

@ExcelIsFun Wow! In 20 minutes I have learned enough to take a required course for my job that will equal better pay! You are an amazing teacher!!!



[VAHIIII]

hoo it's really excellent work and now i am sad i couldn't find ur channel before. Any i completed my Basics. it make me more confident.

Thank u very much. May God bless U..

[ExcelIsFun]

I am glad that you like it!

[Baobao531]

Always learn something new with your work, you are a star.....

[ExcelIsFun]

Just a guy having fun with excel!

Watch this video title to learn how to find the videos that you want;

excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks

[xiaomianyang1956]

Do you know how to use vlookup to get multiple entries with the same look-up value? like:

Type Price

a  $3

a $5

b $4

I want to get all type "a" prices.

Thanks

[ExcelIsFun]

Yes, but it complicated. I have many videos on this topic. Here are 3:

Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula

Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula

Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula

[TheTaylor1959]

where does one download the workbooks from

[ExcelIsFun]

Search for and watch this video title:

excelisfun Search for Excel Videos, Playlists & Download Workbooks

[biswajitdua]

Its great for all us, its real fun. I have completed the Excel Basics. now I am feeling much confident.

[ExcelIsFun]

EXCELlent!!!!

[ExcelIsFun]

I am glad that it was helpful!

[hiei408]

These videos are great sure teaches me a lot about excel tricks that I need for my accounting job.

[ExcelIsFun]

I am glad that they help!

[Xingyi21]

Extremely useful and this guy is plain awesome.

[ExcelIsFun]

Not so much as awesome, just a guy having fun with Excel! I am glad that it had use for you!

[bobbymak880]

Wonderful resource. Well explained too.

[ExcelIsFun]

I am glad that it is useful!

[Justpha]

Another excellent video!

[ExcelIsFun]

Dear Justpha,

I am glad that you found EXCELlence in this video!!

--excelisfun

[jayjavina]

You are amazing!

[ExcelIsFun]

Dear jayjavina,

I am glad that you like it!

It is not that I am amazing, but that I am just a guy having fun with Excel!!

--excelisfun

[jadejadejade07]

superb!.. thumbs up..

[ExcelIsFun]

Dear jadejadejade07 ,

I am glad that you enjoy the videos!

--excelisfun

[erickz34]

This is great !! 5 stars!

[ExcelIsFun]

Dear erickz34,

I am glad that you find the videos helpful!

--excelisfun

[shiryu008]

Another Oscar Award for mike!

[ExcelIsFun]

Dear shiryu008,

EXCELlent!!!!

--ExcelIsFun

[royvaibhav]

Great work!! 5 stars

[ExcelIsFun]

Dear royvaibhav,

Thanks!!!

--ExcelIsFun

[leighton999]

10 stars

[ExcelIsFun]

Dear leighton999,

Thanks! I hope the new knowledge is providing 10 star efficiency at work or at home!!!

--ExcelIsFun

[periwink]

5 stars. Thank you :)

[ExcelIsFun]

Dear periwink,

You Rule!

--ExcelIsFun