VLOOKUP and OFFSET

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to return data on one spreadsheet that is two rows above, and 10
columns accross, from the data that I want to base the search on. I intended
to use a combination of a lookup and an offset command, but have so far been
unable.

Is this possible, or is there an alternative solution?
 
=INDEX(J1:J100,MATCH(Lookup_Value,A1:A100,0)-2)

Of course this will give you problems if the lookup value is in row 2 or
above
 

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

Vlookup to reference offset 1
VLOOKUP and OFFSET 3
Combining Average, Offset & Vlookup 4
VLOOKUP 2
Use vlookup within offset? 4
Integrate OFFSET, INDIRECT and VLOOKUP? 7
Offset/Match Double Lookup 4
Offset VLookup 2

Back
Top