*Also You can Try Offset formula for the same* On Thu, Mar 19, 2009 at 6:50 AM, Alokeshwar Tiwary < [email protected]> wrote:
> > > 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.<http://in.rd.yahoo.com/tagline_messenger_6/*http://messenger.yahoo.com/invite/> >> >> > > > -- > Prabhakar Jain > Mumbai > > ------------------------------ > Add more friends to your messenger and enjoy! Invite them > now.<http://in.rd.yahoo.com/tagline_messenger_6/*http://messenger.yahoo.com/invite/> > > > -- With Regards Love Shrivastava MIS :- RTL, Indore 98270-36531 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
