Dear Friends, It is possible to lookup the values for the left side and second value, third value.... Is their any other ways or functions to get the results.?
1. Shall we can get the left side result by using vlookup function? 2. Shall we can get the second value result by using vlookup function? Thanks in advance. ---------- Forwarded message ---------- From: Prafull Jadhav <prafulltjad...@gmail.com> Date: 10 July 2013 16:52 Subject: Re: $$Excel-Macros$$ Vlookup function using with match & columns To: excel-macros@googlegroups.com Dear Murli, You can just give ref of column,,, for example if you want B column then put (B:B)..... =VLOOKUP($L24,$A$3:$D$6,COLUMN(B:B),0) On Wed, Jul 10, 2013 at 4:43 PM, Muralidhar E <emuralidha...@gmail.com>wrote: > Hi, > Dear friends, > > Thank u > > With the same i want to know using column & columns > > *2.This is using columns or column function* > =vlookup(lookup_value, Table array,*columns or column(array)*,range > lookup). > > I want to know how can we use both these functions. > > 1. Shall we can get the left side result by using vlookup function? > 2. Shall we can get the second value result by using vlookup function? > > Thanks in advance. > On 10 July 2013 16:34, Prafull Jadhav <prafulltjad...@gmail.com> wrote: > >> >> Dear Murli, >> >> Find the same >> >> Regards, >> Prafull Jadhav. >> >> >> On Wed, Jul 10, 2013 at 3:59 PM, Muralidhar E <emuralidha...@gmail.com>wrote: >> >>> Dear friends, >>> >>> Good afternoon, >>> >>> I need a help and I want to know how to use vlookup function by using >>> match and columns function. How it is works? >>> Plz, share with me. >>> >>> *1.This is using match function* >>> =vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match >>> type),*range lookup). >>> >>> *2.This is using columns or column function* >>> =vlookup(lookup_value, Table array,*columns or column(array)*,range >>> lookup). >>> >>> I want to know how can we use both these functions. >>> >>> 1. Shall we can get the left side result by using vlookup function? >>> 2. Shall we can get the second value result by using vlookup function? >>> >>> *Note:* It is more helpful with sharing date by examples. >>> >>> Thanks in advance. >>> >>> >>> ---------- Forwarded message ---------- >>> From: Muralidhar E <emuralidha...@gmail.com> >>> Date: 10 July 2013 15:30 >>> Subject: $$Excel-Macros$$ Vlookup function using with match & columns >>> To: excel-macros@googlegroups.com >>> >>> >>> >>> Dear friends, >>> >>> Good afternoon, >>> >>> I need a help and I want to know how to use vlookup function by using >>> match and columns function. How it is works? >>> Plz, share with me. >>> >>> *1.This is using match function* >>> =vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match >>> type),*range lookup). >>> >>> *2.This is using columns function* >>> =vlookup(lookup_value, Table array,*columns(array)*,range lookup). >>> >>> I want to know how can we use both these functions. >>> >>> 1. Shall we can get the left side result by using vlookup function? >>> 2. Shall we can get the second value result by using vlookup function? >>> >>> *Note:* It is more helpful with sharing date by examples. >>> >>> Thanks in advance. >>> -- >>> *Thanks & Regards,* >>> ** >>> *Muralidhar E.* >>> Think different >>> Do Different >>> Make different >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> >>> >>> >>> >>> -- >>> *Thanks & Regards,* >>> ** >>> *Muralidhar E.* >>> Think different >>> Do Different >>> Make different >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> >>> >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > > > -- > *Thanks & Regards,* > ** > *Muralidhar E.* > Think different > Do Different > Make different > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Thanks & Regards,* ** *Muralidhar E.* Think different Do Different Make different -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
