View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nick H[_2_] Nick H[_2_] is offline
external usenet poster
 
Posts: 11
Default 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.