VLOOKUP Across Multiple Tables CHOOSE & VLOOKUP

preview_player
Показать описание
In our scenario we have to apply discounts to product sales based on quantity ordered and product category, Essentially there a multiple lookup tables that we need to reference through one formula. This video shows you one of achieving this by combining VLOOKUP with the CHOOSE function.
------------------------
Рекомендации по теме
Комментарии
Автор

Well Explained a beautiful and useful trick for the excel users. Thanks a lot. Hope many more videos are on the anvil in the days to come for the benefit of the Excel User( Excel User Friendly techniques)

gopalakrishnarao