Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
New to excell and i would like to utilize vlookup to avoid repetitive steps.
I have the formula for a two column list =VLOOKUP(A9,A1:B7,2,FALSE) but not sure how to configure going horizontal like from A1 TO E1 can someone assit please? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
Use HLOOKUP. It works the same as VLOOKUP only horizontaly.
=HLOOKUP(A9,A1:E2,2,0) In VLOOKUP you define the column_index_number but in HLOOKUP you define the row_index_number. -- Biff Microsoft Excel MVP "acss" wrote in message ... New to excell and i would like to utilize vlookup to avoid repetitive steps. I have the formula for a two column list =VLOOKUP(A9,A1:B7,2,FALSE) but not sure how to configure going horizontal like from A1 TO E1 can someone assit please? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
Hi,
I have my text value in a1 and would like a number to appear in e1 so in your response how would i configure the formula? "T. Valko" wrote: Use HLOOKUP. It works the same as VLOOKUP only horizontaly. =HLOOKUP(A9,A1:E2,2,0) In VLOOKUP you define the column_index_number but in HLOOKUP you define the row_index_number. -- Biff Microsoft Excel MVP "acss" wrote in message ... New to excell and i would like to utilize vlookup to avoid repetitive steps. I have the formula for a two column list =VLOOKUP(A9,A1:B7,2,FALSE) but not sure how to configure going horizontal like from A1 TO E1 can someone assit please? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
I may have misunderstood what you're trying to do.
Can you provide more specific details? -- Biff Microsoft Excel MVP "acss" wrote in message ... Hi, I have my text value in a1 and would like a number to appear in e1 so in your response how would i configure the formula? "T. Valko" wrote: Use HLOOKUP. It works the same as VLOOKUP only horizontaly. =HLOOKUP(A9,A1:E2,2,0) In VLOOKUP you define the column_index_number but in HLOOKUP you define the row_index_number. -- Biff Microsoft Excel MVP "acss" wrote in message ... New to excell and i would like to utilize vlookup to avoid repetitive steps. I have the formula for a two column list =VLOOKUP(A9,A1:B7,2,FALSE) but not sure how to configure going horizontal like from A1 TO E1 can someone assit please? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
My goal is to have two lists, one for an description and another for an
account. I thought to have a drop down list in A2 for a DESCRIPTION and when a certain description is selected then a corresponding account would appear in E2. Is this not what vlookup is for? New to excell sorry for confusion! "T. Valko" wrote: I may have misunderstood what you're trying to do. Can you provide more specific details? -- Biff Microsoft Excel MVP "acss" wrote in message ... Hi, I have my text value in a1 and would like a number to appear in e1 so in your response how would i configure the formula? "T. Valko" wrote: Use HLOOKUP. It works the same as VLOOKUP only horizontaly. =HLOOKUP(A9,A1:E2,2,0) In VLOOKUP you define the column_index_number but in HLOOKUP you define the row_index_number. -- Biff Microsoft Excel MVP "acss" wrote in message ... New to excell and i would like to utilize vlookup to avoid repetitive steps. I have the formula for a two column list =VLOOKUP(A9,A1:B7,2,FALSE) but not sure how to configure going horizontal like from A1 TO E1 can someone assit please? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
Yes, but you asked how to go from a vertical lookup to a horizontal lookup.
A1 = lookup value = X Vertical lookup table in the range D1:E5 V...Bob W...Sue X...Sam Y...Tia Z...Tom =VLOOKUP(A1,D1:E5,2,0) returns Sam Horizontal lookup table in the range D1:H2 ...V......W......X.......Y......Z Bob...Sue...Sam....Tia...Tom =HLOOKUP(A1,D1:H2,2,0) returns Sam The only difference between H/VLOOKUP is in VLOOKUP you tell it what *column* to look in for the result and with HLOOKUP you tell it what *row* to look in for the result. -- Biff Microsoft Excel MVP "acss" wrote in message ... My goal is to have two lists, one for an description and another for an account. I thought to have a drop down list in A2 for a DESCRIPTION and when a certain description is selected then a corresponding account would appear in E2. Is this not what vlookup is for? New to excell sorry for confusion! "T. Valko" wrote: I may have misunderstood what you're trying to do. Can you provide more specific details? -- Biff Microsoft Excel MVP "acss" wrote in message ... Hi, I have my text value in a1 and would like a number to appear in e1 so in your response how would i configure the formula? "T. Valko" wrote: Use HLOOKUP. It works the same as VLOOKUP only horizontaly. =HLOOKUP(A9,A1:E2,2,0) In VLOOKUP you define the column_index_number but in HLOOKUP you define the row_index_number. -- Biff Microsoft Excel MVP "acss" wrote in message ... New to excell and i would like to utilize vlookup to avoid repetitive steps. I have the formula for a two column list =VLOOKUP(A9,A1:B7,2,FALSE) but not sure how to configure going horizontal like from A1 TO E1 can someone assit please? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
At first i received a circular reference but now as i type x into a1 then i
get sam. In regards to expanding on the horizotal list , such as additional data would you reccommend placing the list on another sheet out of end user view and link the cells? "T. Valko" wrote: Yes, but you asked how to go from a vertical lookup to a horizontal lookup. A1 = lookup value = X Vertical lookup table in the range D1:E5 V...Bob W...Sue X...Sam Y...Tia Z...Tom =VLOOKUP(A1,D1:E5,2,0) returns Sam Horizontal lookup table in the range D1:H2 ...V......W......X.......Y......Z Bob...Sue...Sam....Tia...Tom =HLOOKUP(A1,D1:H2,2,0) returns Sam The only difference between H/VLOOKUP is in VLOOKUP you tell it what *column* to look in for the result and with HLOOKUP you tell it what *row* to look in for the result. -- Biff Microsoft Excel MVP "acss" wrote in message ... My goal is to have two lists, one for an description and another for an account. I thought to have a drop down list in A2 for a DESCRIPTION and when a certain description is selected then a corresponding account would appear in E2. Is this not what vlookup is for? New to excell sorry for confusion! "T. Valko" wrote: I may have misunderstood what you're trying to do. Can you provide more specific details? -- Biff Microsoft Excel MVP "acss" wrote in message ... Hi, I have my text value in a1 and would like a number to appear in e1 so in your response how would i configure the formula? "T. Valko" wrote: Use HLOOKUP. It works the same as VLOOKUP only horizontaly. =HLOOKUP(A9,A1:E2,2,0) In VLOOKUP you define the column_index_number but in HLOOKUP you define the row_index_number. -- Biff Microsoft Excel MVP "acss" wrote in message ... New to excell and i would like to utilize vlookup to avoid repetitive steps. I have the formula for a two column list =VLOOKUP(A9,A1:B7,2,FALSE) but not sure how to configure going horizontal like from A1 TO E1 can someone assit please? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
That just boils down to user preference.
You could put the table on one sheet (you can even hide that sheet) and use the formula on another sheet: =HLOOKUP(A1,Sheet10!D1:H2,2,0) -- Biff Microsoft Excel MVP "acss" wrote in message ... At first i received a circular reference but now as i type x into a1 then i get sam. In regards to expanding on the horizotal list , such as additional data would you reccommend placing the list on another sheet out of end user view and link the cells? "T. Valko" wrote: Yes, but you asked how to go from a vertical lookup to a horizontal lookup. A1 = lookup value = X Vertical lookup table in the range D1:E5 V...Bob W...Sue X...Sam Y...Tia Z...Tom =VLOOKUP(A1,D1:E5,2,0) returns Sam Horizontal lookup table in the range D1:H2 ...V......W......X.......Y......Z Bob...Sue...Sam....Tia...Tom =HLOOKUP(A1,D1:H2,2,0) returns Sam The only difference between H/VLOOKUP is in VLOOKUP you tell it what *column* to look in for the result and with HLOOKUP you tell it what *row* to look in for the result. -- Biff Microsoft Excel MVP "acss" wrote in message ... My goal is to have two lists, one for an description and another for an account. I thought to have a drop down list in A2 for a DESCRIPTION and when a certain description is selected then a corresponding account would appear in E2. Is this not what vlookup is for? New to excell sorry for confusion! "T. Valko" wrote: I may have misunderstood what you're trying to do. Can you provide more specific details? -- Biff Microsoft Excel MVP "acss" wrote in message ... Hi, I have my text value in a1 and would like a number to appear in e1 so in your response how would i configure the formula? "T. Valko" wrote: Use HLOOKUP. It works the same as VLOOKUP only horizontaly. =HLOOKUP(A9,A1:E2,2,0) In VLOOKUP you define the column_index_number but in HLOOKUP you define the row_index_number. -- Biff Microsoft Excel MVP "acss" wrote in message ... New to excell and i would like to utilize vlookup to avoid repetitive steps. I have the formula for a two column list =VLOOKUP(A9,A1:B7,2,FALSE) but not sure how to configure going horizontal like from A1 TO E1 can someone assit please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Question | Excel Discussion (Misc queries) | |||
VLOOKUP question | Excel Discussion (Misc queries) | |||
VLOOKUP question...it probably can't... | Excel Discussion (Misc queries) | |||
VLOOKUP Question.. | Excel Discussion (Misc queries) | |||
VLOOKUP question | Excel Discussion (Misc queries) |