Can Vlookup accomplish this?

  • Thread starter Thread starter osp
  • Start date Start date
O

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need VLOOKUP to Work Two Ways 0
using hlookup to reference a column in a vlookup formula? 3
Vlookup to reference offset 1
Can Vlookup accomplish this? 2
How to add a cell value to VLOOKUP? 5
Vlookup and return sheet name also 2
VLookup vs. Match/Index 6
VLookup Data, Find 2 Adjacent Rows, Return Value in 1 Row 3

Back
Top