Can Vlookup accomplish this?

[osp]

Hi I was wondering if vlookup can go over a specified number of column
and go over a specified number of rows as well. I tried using vlooku
with index but didn't have any luck getting that to work. I basicall
need something that uses vlookup to find the cell then go over
columns and down 10 rows and retrieve that data.
Any suggestions would be greatly appreciated

 

[Arvi Laanemets]

Hi

With the lookup table in range A1:E100 and lookup values in column A:

=OFFSET($A$1;MATCH(LookupValue;$A1:$A$100;0)+10-1;5-1)

(The LookupValue can be the value of any type)


Arvi Laanemets