Use the Choose Function to display data in Excel

Use the Choose Function to display data in Excel. Use the Choose Function in combination with Vlookup to display information from different tables in Excel. Naming you tables speeds up the section of data. Simply enter the name of the table in the formula and the data from the table will be selected.
The Formula that I used
=vlookup(value, choose(index, table1, table2, table3),2,0)

Contact me regarding customizing this template for your needs.

I am able to provide online help on your computer at a reasonable rate.

Check out my next one-hour Excel Webinar

I use a Blue condensor Microphone to record my videos, here is the link

Check out Crowdcast for creating your webinars

If you need to buy Office 2019 follow

I use Tube Buddy to help promote my videos
Check them out

Follow me on Facebook

TWEET THIS VIDEO

Follow me on twitter
easyexcelanswers

IG @barbhendersonconsulting

You can help and generate a translation to you own language

*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I've used or have experience with.

[BarbHendersonconsulting]

Thank you so much for watching my video. If you have any suggestions for future topics, please leave them in the comments.

[lokeshnaidurepalle]

Wonderful video Barb, Could you make a video on dependent drop downs to create table from master data