Highline Excel Class 40: VLOOKUP 11 Unusual Examples

[arofairy]

I m really grateful, no doubt you are excellent teacher!!! you are my teacher, salute you!!!!! great work!!!

[ExcelIsFun]

@arofairy , I am glad that the videos help!!

[hersheng18]

these infos are really very helpful. thank you so much.

[ExcelIsFun]

@hersheng18 , you are welcome!

[gnossticc]

"A great tool always needs a great teacher"

This is for you Mike, thanks!

I hope you are feeling much better from your wrist!

[ExcelIsFun]

You are welcome!

[maralghawsi]

Thank you very much for your videos, you explain them very well. I've been youtubing for a while now trying to find a specific function of the vlookup. Say for example, you're looking up the TOTAL value of all bills sent to a client (e.g. client A) so the table array would include client A more than once if more than 1 invoice was sent. How do I get VlookUp to retrieve the SUM of all bills sent to client A, not just the value of one of the bills? Thank you :)

[ExcelIsFun]

Try this video:

Excel Magic Trick 320: Lookup Adding: SUMPRODUCT & SUMIF

[maralghawsi]

@ExcelIsFun Thank you for the link, but it's not exactly what I was looking for. With sumif/sumproduct, you have to insert your criteria, what to look for and the info to retrieve. I was just hoping to use vlookup to look for a value and retrieve the sum of everything found in the table with the value searched. Not sure how I am?!?!

[ExcelIsFun]

I thought SUMPRODUCT and SUMIF would do that. I do not have a good answer for you. Try posting your question to THE best Excel site:

mrexcel[dot]com/forum

[MsGnorts]

Dear Mike: How can I add more currencies to the "currency exchange rate web query"?

I need those of Central American countries.

Thanks

[ExcelIsFun]

I do not know. But no problem, try this site:

mrexcel..com/forum

I am sure one of the 100+ Excel gurus there will have a good answer!

After you post, send me the link so that I can follow along and learn also!

[MsGnorts]

@ExcelIsFun

OK I'll keep you up to date. :-)

[moazzamca1]

The one with wild card was awesome.

[ExcelIsFun]

I am glad that it is helpful!

[Rebuild8]

Hi Mike,

I downloaded the Week8Busn214Finished file and went to the V(10) sheet and tried some of the currencies. However, when I chose certain ones in A6, cell C5 did not seem to work properly. For example, choosing "Hungarian Forint to US Dollar" in A6 returned "Hungarian For" in C5. Why didn't it find the " to "? "Thai Baht to US Dollar" adds the " to ". Very weird.

[ExcelIsFun]

Can you send me the workbook with an explanation of where the problem is and what you expect the correct answer to be:

excelisfun at gmail

I'll take a look.

[ioneveu]

HI, just a quick question:

does the * sign also works when using it in defining the criteria for the advanced filter?

[ExcelIsFun]

Yes. If you enter the criteria W* for a field that contains West and Win, it will extract all records that contain West and Win.

[sripran1722]

Hi,

I was thinking (as we have already downloaded the startfile), it will be a good idea for learners, if we are given some challenges/exercises to work on at the end of tutorials.

Thanks.

[ExcelIsFun]

I have no idea how to do that in Excel. I think Access can do it, but I do not do videos on Access.

[microsuez]

Very comprehensive!

[ExcelIsFun]

Yes, this one was particularly fun to make!!

[mrsharbort]

hi I am looking for vlookup for pictures, is there a tutorial for that. thanks a lot

[maxandbrener]

I love Vlookup because of you! I teach my colleagues.

I also like your videos with Mr. Excell!

[ExcelIsFun]

Dear maxandbrener,

Me too! I love VLOOKUP! As Mr Excel posted at a jobs site to advertise himself:

"Can do VLOOKUP in my sleep!"

If you know how to use VLOOKUP it is easier to get a job!

--excelisfun

[zerobeholder]

I subscribed to your channel a while ago, these videos are very well done. I'm sure a measure of work and preparation goes into them. I consider myself an Excel guru and I've picked a few things up from you...

[ExcelIsFun]

Dear zerobeholder,

I am glad that the videos help! They do take a while to make, but it sure is fun to make them!!

Hey, if you liked this one, try the video title:

Highline Excel Class 45: INDEX & MATCH 12 Unusual Examples

--excelisfun

[sep1101]

Great. Thanks.

[ExcelIsFun]

Dear sep1101,

You are welcome!

--excelisfun