Excel Lookup Series #3: VLOOKUP Function 3rd Example

See how to Use VLOOKUP to deliver a value to a formula. See how to deliver a late fee percentage to a formula using the VLOOKUP. In a formula, the VLOOKUP function can evaluate to a number that the formula can use to make a calculation.

In This Series learn 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel.

This is a logical (beginning to end) story about most of the lookup situations you may encounter in Excel.

Category:

Science & Technology

Tags:

• Excel
• VLOOKUP
• function
• value
• to
• formula
• late
• fee
• percentage
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[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

[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!

[biswajitdua]

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

[ExcelIsFun]

I am glad that it was helpful!

[Xingyi21]

Extremely useful and this guy is plain awesome.

[akkas013]

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

[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!!!

[john22112]

This guys school boy enthusiasm is killing me lol

[ExcelIsFun]

I am glad that you like it!

[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..