VLOOKUP use column name not number
in [Functions]
|
Prev: Forecasting
Next: Average range of discontinuous cells
From: T. Valko on 11 May 2010 16:03 >...MATCH('Income Variance'!B3,History1!B1:BU197,0)... The lookup_array argument in MATCH must be a one dimenonsional array. Try it like this... =VLOOKUP(A4,History1!B1:BU218,MATCH('Income Variance'!B3,History1!B1:BU1,0),0) -- Biff Microsoft Excel MVP "kathy" <kathy(a)discussions.microsoft.com> wrote in message news:609C5E61-9878-420C-AAF5-9255C6909623(a)microsoft.com... > =VLOOKUP(A4,History1!B1:BU218,MATCH('Income > Variance'!B3,History1!B1:BU197,0),0) > I tried this and get #N/A. > > A4 is the row name that is to be looked up. > history1 B1:bu218 is the worksheet name to find the data on > 'income variance'! B3 is the column title to be looked up('income > variance' > is the name of the worksheet that is looking for the information) > history1 B1:bu218 is the worksheet with the data on it again > > Am I missing something? > > -- > Thank you, Kathy > > > "T. Valko" wrote: > >> Something like this... >> >> =VLOOKUP("this",A:J,MATCH("column_name",A1:J1,0),0) >> >> -- >> Biff >> Microsoft Excel MVP >> >> >> "kathy" <kathy(a)discussions.microsoft.com> wrote in message >> news:ACEB47EE-CDD3-4E92-9332-B3B4A99C00EB(a)microsoft.com... >> > Is there a way to use VLOOKUP to search for a column name and return >> > the >> > value in that column, rather search for a column number. >> > >> > -- >> > Thank you, Kathy >> >> >> . >>
From: kathy on 11 May 2010 17:10 Thank you, that worked!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! -- Thank you, Kathy "T. Valko" wrote: > >...MATCH('Income Variance'!B3,History1!B1:BU197,0)... > > The lookup_array argument in MATCH must be a one dimenonsional array. Try it > like this... > > =VLOOKUP(A4,History1!B1:BU218,MATCH('Income > Variance'!B3,History1!B1:BU1,0),0) > > -- > Biff > Microsoft Excel MVP > > > "kathy" <kathy(a)discussions.microsoft.com> wrote in message > news:609C5E61-9878-420C-AAF5-9255C6909623(a)microsoft.com... > > =VLOOKUP(A4,History1!B1:BU218,MATCH('Income > > Variance'!B3,History1!B1:BU197,0),0) > > I tried this and get #N/A. > > > > A4 is the row name that is to be looked up. > > history1 B1:bu218 is the worksheet name to find the data on > > 'income variance'! B3 is the column title to be looked up('income > > variance' > > is the name of the worksheet that is looking for the information) > > history1 B1:bu218 is the worksheet with the data on it again > > > > Am I missing something? > > > > -- > > Thank you, Kathy > > > > > > "T. Valko" wrote: > > > >> Something like this... > >> > >> =VLOOKUP("this",A:J,MATCH("column_name",A1:J1,0),0) > >> > >> -- > >> Biff > >> Microsoft Excel MVP > >> > >> > >> "kathy" <kathy(a)discussions.microsoft.com> wrote in message > >> news:ACEB47EE-CDD3-4E92-9332-B3B4A99C00EB(a)microsoft.com... > >> > Is there a way to use VLOOKUP to search for a column name and return > >> > the > >> > value in that column, rather search for a column number. > >> > > >> > -- > >> > Thank you, Kathy > >> > >> > >> . > >> > > > . >
From: T. Valko on 11 May 2010 20:45
Good deal. Thanks for the feedback! -- Biff Microsoft Excel MVP "kathy" <kathy(a)discussions.microsoft.com> wrote in message news:C48550E7-924C-45B3-A8B3-BCD13898FE14(a)microsoft.com... > Thank you, that worked!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! > -- > Thank you, Kathy > > > "T. Valko" wrote: > >> >...MATCH('Income Variance'!B3,History1!B1:BU197,0)... >> >> The lookup_array argument in MATCH must be a one dimenonsional array. Try >> it >> like this... >> >> =VLOOKUP(A4,History1!B1:BU218,MATCH('Income >> Variance'!B3,History1!B1:BU1,0),0) >> >> -- >> Biff >> Microsoft Excel MVP >> >> >> "kathy" <kathy(a)discussions.microsoft.com> wrote in message >> news:609C5E61-9878-420C-AAF5-9255C6909623(a)microsoft.com... >> > =VLOOKUP(A4,History1!B1:BU218,MATCH('Income >> > Variance'!B3,History1!B1:BU197,0),0) >> > I tried this and get #N/A. >> > >> > A4 is the row name that is to be looked up. >> > history1 B1:bu218 is the worksheet name to find the data on >> > 'income variance'! B3 is the column title to be looked up('income >> > variance' >> > is the name of the worksheet that is looking for the information) >> > history1 B1:bu218 is the worksheet with the data on it again >> > >> > Am I missing something? >> > >> > -- >> > Thank you, Kathy >> > >> > >> > "T. Valko" wrote: >> > >> >> Something like this... >> >> >> >> =VLOOKUP("this",A:J,MATCH("column_name",A1:J1,0),0) >> >> >> >> -- >> >> Biff >> >> Microsoft Excel MVP >> >> >> >> >> >> "kathy" <kathy(a)discussions.microsoft.com> wrote in message >> >> news:ACEB47EE-CDD3-4E92-9332-B3B4A99C00EB(a)microsoft.com... >> >> > Is there a way to use VLOOKUP to search for a column name and return >> >> > the >> >> > value in that column, rather search for a column number. >> >> > >> >> > -- >> >> > Thank you, Kathy >> >> >> >> >> >> . >> >> >> >> >> . >> |