Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question on looking up data
I have a large table, and I am using VLOOKUP to find data. What I need is a
way to get Excel to return the value in the cell immediately below the one that contains the value that VLOOKUP finds. For example, let's say VLOOKUP(10,A1:C:200,2) returns a value from B50. The value I want is in B51; how can I get that? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question on looking up data
Nick
Use a combination of INDEX() and MATCH() functions =INDEX(A1:C200,MATCH(10,A1:A200,0)+1,2) If this post helps click Yes --------------- Jacob Skaria "Nick H" wrote: I have a large table, and I am using VLOOKUP to find data. What I need is a way to get Excel to return the value in the cell immediately below the one that contains the value that VLOOKUP finds. For example, let's say VLOOKUP(10,A1:C:200,2) returns a value from B50. The value I want is in B51; how can I get that? Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question on looking up data
Perfect! Thanks.
"Jacob Skaria" wrote: Nick Use a combination of INDEX() and MATCH() functions =INDEX(A1:C200,MATCH(10,A1:A200,0)+1,2) If this post helps click Yes --------------- Jacob Skaria "Nick H" wrote: I have a large table, and I am using VLOOKUP to find data. What I need is a way to get Excel to return the value in the cell immediately below the one that contains the value that VLOOKUP finds. For example, let's say VLOOKUP(10,A1:C:200,2) returns a value from B50. The value I want is in B51; how can I get that? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Table Question? | Excel Discussion (Misc queries) | |||
Data Validation Question | Excel Discussion (Misc queries) | |||
Data Validation Question | Excel Discussion (Misc queries) | |||
Fill data question | Excel Discussion (Misc queries) | |||
Data parsing question | Excel Worksheet Functions |