VLOOKUP Formula with Conditional Lookup Table
HTML-код
- Опубликовано: 16 янв 2015
- Set up a conditional lookup table for your VLOOKUP formula. If you have multiple lookup tables for your VLOOKUP formula, it may be worth setting up a conditional lookup table where the user specifies the lookup table to use.
This video shows how the INDIRECT function used with VLOOKUP to reference named ranges and have the lookup table dependent upon a user selection from a list.
Find more great free tutorials at;
www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1 - Хобби
You just saved me an enormous amount of time with this video. Thank you
Glad it helped! You're welcome, Donovan.
no words can explain my Admiration to this videos
Thank you Hazem.
Really good video. I found it very helpful. Sticking to your example, if i replaced Product category with employee name. Count with months and sales value with commission. Now my requirement is to be able to choose an employee from the list, select a month and it should give me the commission for that employee that month using VLOOKUP. Can we do that with indirect function for dates
please sir, i would want you to show me how i can create the blank environment of excel for the 6 numbers draw in the Euro million. i did the first sheet(calculations) but when i put the lookup function of the first cell (C7) and Enter it, it indicated error. please sir, show me what i can do to create that blank sheet of excel environment containing the six cell box. thaks.
Hi Alan.. thanks for this video.. cool trick. Do you offer a download of your tutorial workbooks for viewers to practice the lesson? I couldn't find a link on RUclips or your site, so I built a duplicate of your 3 tables, data validation drop-downs and Vlookup function with Indirect function. So, some good learning, but lots of typing to get to the point of practicing the actual formula and technique. If you offer a download of your practice files, please let me know how to access them. Either way.. Thumbs up!
Thanks Wayne. Some tutorials have downloads and some do not. I normally provide downloads for more complex spreadsheets.
Thank you for the suggestion.
Where can i donwload the example? also please give info that what is care to be taken for the table structure of different country?
Hello I found the video very interesting, I do have a question about this, You have a name in cell B2 but if you now combine a letter with a number (in my case, for example S1) then what? Can you help me?
Thank you Gerard. You scenario you mention should work fine with the same technique. You cannot name a range beginning with a number, but you can end with one.
Can you give me an example?
It would be the same. Each table would be named such as S1, S2 like you mention. Then you follow the video but using that name. To name a table - select it, and then enter the name into the name box to the left of the formula bar, and press enter.
Hello sir, Can I also do this in VBA and so rows go down (20) also columns aside (3), is that possible, how do I do this? can you halp with a small example?
Sure. You can easily test a cell value and then search in a specific range or name. It sounds like you may be new to VBA and would benefit from some structured training. Difficult to provide an example when the foundation is not understood.
Hello, how can I follow a VBA course, is there a document course that I can read?