Vlookup with Choose function in hindi || Reverse vlookup ||
A very warm welcome to all my viewers in EXCEL4LEARN Channel. Today in this video I cover how to use vlookup formula with another choose function in excel in hindi. Using this combination we can reverse the property of vlookup and converted into lookup function.
what is vlookup?
VLOOKUP stands for ‘Vertical Lookup’. It is a function that makes Excel search for a certain value in a column (the so called ‘table array’), in order to return a value from a different column in the same row.
what is choose function?
he Microsoft Excel CHOOSE function returns a value from a list of values based on a given position.
The CHOOSE function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) and a VBA function (VBA) in Excel. As a worksheet function, the CHOOSE function can be entered as part of a formula in a cell of a worksheet.
In Excel tutorial I’m going to show you how you can do a lookup to the left with a VLOOKUP formula together with the CHOOSE function as an alternative.
#EXCEL4LEARN
YouTube Playlist URL:-
• MS-Excel Tutorial by Akshay
LIKE,SUPPORT and SHARE
PLease press SUBSCRIBE Button and hit the bell icon for notification.
LIke my FB Page:- / excel4learn
Instagram Id:- akshay_d13
Google + :- https://plus.google.com/b/10259595250...
LinkedIn: / akshay-dey-028101138
#vlookup #choose_function #choosewithvlookup