ExcelBanter - Question on looking up data

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Question on looking up data (https://www.excelbanter.com/excel-worksheet-functions/233035-question-looking-up-data.html)

Nick H[_2_]

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.

Jacob Skaria

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.

Nick H[_2_]

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.

All times are GMT +1. The time now is 10:20 AM.