Prabhakar, Here is the structure of the Function: MyVLookUp(Lookup_Value As String, Lookup_Range As Range, Column_Index As Long, Optional Left_Lookup As Boolean)
Lookup_Value = same as lookup_value in vlookup Lookup_Range = same as table_array in vlookup, but here you need to select a single column only else it will return an error (#INVALID!), for example "A:A" or A1:A10 is a valid range but "A:B" or A1:B10 is invalid. Column_Index = same as in vlookup, if you have value in Column D and want to look up in Column F or Column B, the Column_Index will be 2 Left_Lookup = if value is 0 or FALSE and your Lookup_Range is Column D and Column_Index is 2 then it will return result from Column F if value is 1 or TRUE then it will return result from Column B (Left side of your Lookup_Range i.e. Column D) Please let me know if you have any questions. _________________________________________________________________________________________________ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know." ________________________________ From: prabhakar jain <[email protected]> To: [email protected] Sent: Wednesday, 18 March, 2009 1:23:34 PM Subject: $$Excel-Macros$$ Re: Left VLookup Please explain it little bit extensivly. It is a good function but proper usage is not clear from ur example. On Tue, Mar 17, 2009 at 7:43 AM, Alokeshwar Tiwary <[email protected]> wrote: Just thought of sharing this function with the group. I created it to elaminate lengthy match index formula from my reports _________________________________________________________________________________________________ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know." ________________________________ Add more friends to your messenger and enjoy! Invite them now. -- Prabhakar Jain Mumbai Bollywood news, movie reviews, film trailers and more! Go to http://in.movies.yahoo.com/ --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] or Ashish Jain @ [email protected] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
MyVLookUp.xls
Description: MS-Excel spreadsheet
