CODEWITHSUNDEEP
excelexcel-2003
Lee_Str
Lee_Str

Reputation: 3496

reference next row and column for vlookup in excel

I know I need to use Index and Match, but these functions confuse me.

Column A     Column B
String       Value
Apple        10
Apple        20
Grape        10

(This is an example, and not the data I'm actually using)

I'm trying to pull the value of 20 for the second listing of Apple.

Upvotes: 0

Views: 10310

Answers (1)

FoodCriticMike
FoodCriticMike

Reputation: 84

This is the formula that will do it: =INDEX(B2:B4,MATCH(C2,A2:A4,0)+1)

Your data range is in A2:B4. In C2 put the value that you want to look up - "Apple". In D2 copy in the formula from here, it will return 20 from the second "Apple" line.

Upvotes: 4

Related Questions