Mr Excel & excelisfun Trick 40: VLOOKUP to 3 Different Lookup Tables (3 table_arrays)

[dmr450]

This is a great video. The volatile vs non volatile, the choose function, named ranges usage is truly great!

Really!

Thanks.

Dave

[ExcelIsFun]

@dmr450 , coming from a true Excel Master like you, that is quite a compliment!!!

[programSense]

man you guys are crazy...in a good way. This will really come in handy, I used nested if's for these situations and the formulas were too tedious.

[ExcelIsFun]

I am glad that that it is helpful!!

--excelisfun

[rameshsolonely]

i am so happy to see you new video every time it very very work full to me in my daily work i am working in F&B do you have easy formula to make accurate inventory .

how can i count by vlookup same code 2 time in one sheet Sunjoy Kuwait thank you very much for help me to teach me more happy Holiday !!!!!!!!!!!

[ExcelIsFun]

For counting, try this video title:

Excel Magic Trick #180: COUNTIF function formula 21 Examples

For inventory, try:

Excel Magic Trick 348: Formula for Unit Inventory Total SUMIF function Trick

or

YTLE#79: Formula for Running Total (Inventory)

[planiolro]

totally cool. One of the best duel I have ever seen. Superrrrrrrrrrrrrrrrr

[ExcelIsFun]

EXCELlenttttttttttttt!!

I hope that we can come up with others that are nearly as cool!!!

[rvg14344]

I don't how can I thank both of you for sharing your cleverness to the world.

[ExcelIsFun]

You are welcome! I am happy that the trick is useful!

[lordway]

Thanks! Indirect and Choose functions will help with a tax calculation tool I'm working on when it comes to picking the right tax table for the filing status.

[ExcelIsFun]

EXCELlent!!! That is one of the uses that I use this trick for also: Weekly Payroll Allowances for maries and single.

[kami645464]

Another great excel tutorial! This makes life so much more interesti ng. Experimenting in Excel has become one of my hobby thanks to you.

[ExcelIsFun]

I agree: experimenting in Excel is more fun that almost evrything else!

[mikeyroro]

Once again, impressive. I'm guessing this will save me a lot of time in the near future! Thanks!

Mike

[ExcelIsFun]

I am glad that the video is useful!!!!

[krn14242]

Another great duel... Merry Christmas Mike (Issac), and Bill.

kevin

[ExcelIsFun]

Merry Christmas and Happy Holidays, Kevin! -- Mike

123456789hyggioooooxxxxxxxxxxx xxxxxxxxxxxxxxxblghpjkojoupjup iopip-ppipiopu-puoiop --Isaac

(Isaac's says Have a Cool Holiday!)

[baishamao]

Hey guys - well I learnt some. But none of these address the Drop Down Box Query.

But you are all too clever for me.

Have a lovely Christmas though. xX

[ExcelIsFun]

Can't you just have the named ranges in a drop-down?