Excel Magic Trick

Download Excel Start File: h people.highlin...
Download Excel Finished File: people.highlin...
Full Page With All File Links: people.highlin...
See how use VLOOKUP when there are 3 tables on 3 different sheets. See how to use the VLOOKUP & INDIRECT functions as well as named cell ranges in a formula that can handle lookup in three 3 different tables. Also see an Excel Consolidation to accomplish the same task.

[@excelisfun]

Dear cidfidoutube, I am glad that it helped. I am such a bad speller, I just thought Fev should have been feb (the b key is right next to the b key). --excelisfun

[@TheMrBenjamin]

Excellent work. You da man!!

[@mercy2mercy]

Great Work man, Good Luck

[@excelisfun]

Dear tdhildr, I hope it provides use for you! --excleisfun

[@excelisfun]

Maybe: =VLOOKUP(TRIM($B8),INDIRECT(C$7),2,0)

[@excelisfun]

There is another way to do this also. See the "Highline Excel Class CHOOSE function" video.

[@joker4835]

I need some help i have to combine two excel spreadsheets. I need to tak vallue from collumn B look it up at collumn K in second spreadsheet and based on these vallues bring informations from collumn J. (Collumn B Spr1 Box name, collumn KSpr2 Box name, Collumn JSpr2 UniqueID) does this make sense? I am lost on how to get it done...

[@excelisfun]

Dear mercy2mercy, I glad the video is useful! --excelisfun

[@CarpenterMazur]

Hi I am trying to vlookup across multiple sheets but i have to concatenate the value that i am looking for in the vlookup. I have to pull to codes together which form the code that has to be searched on in the multiple worksheets. How would this best be done. this is what i have come up with so far =VLOOKUP(CONCATENATE(GI381,A2321)),PWS!A:F,6,false PWS!A:F is the worksheet i am looking at

[@nuthannuthan479]

sir, i am getting ref! as a comment in the cell after using the above method, please advice

[@cruzdt]

In that example where 'pam' had a space, where would TRIM be? How would that formula look? Thank you.

[@dominictagle]

hi, is the formula also work if refer into another worksheets? thanks!

[@excelisfun]

Yes.

[@notunusual7827]

Thank you very much! I was trying to understand this combinational formula of -Vlookup&Indirect since one month, Everyday I tried any new tutorial that popped up by google searching but I couldn't make that! But right now after watching this simple and awesomely explained tutorial - I'VE GOT IT!!!! Thanks~

[@janzolna5899]

I have a question: I have Vlookup formula and based on dropdown it is pulling data from other sheet. Now I want That if I change value in dropdown, vlookup formula will go to different sheet and pull data from there and so on. Any Idea

[@houlmouth]

So to search multiple sheets with multiple tables you HAVE to name each range that is being searched? Well I have a workbook of 80 separate sheets each sheet having multiple tables, i don't see VLOOKUP working for me. Seeing that each sheet i have to go in & name each individual range, that would be too time consuming. Do you have a solution to a situation like this?

[@tdhildr]

All i can say is "Wow"!

[@vasilisa6128]

Thank you very much! It was very interesting!

[@cruzdt]

Oh wow thanks! You're on top of this when it comes to responses!