offseting formula

  • Thread starter Thread starter Daniel Bonallack
  • Start date Start date
D

Daniel Bonallack

Can I offset from a vlookup result?

Say I have names in column A, and sales in column B. Can
I vlookup John Smith's sales, but return the sales from
the person two rows below him?

Thanks in advance

Daniel
 
Why not use MATCH to find John Smith's row and then OFFSET(2,1)
 
You must log in or register to reply here.

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

Offset Question 4
V/HLOOKUP in both directions? 5
VLOOKUP and OFFSET 3
vlookup or index/match formula?? 2
Vlookup to reference offset 1
Vlookup and retrieve values 1 row below the normally retrieved val 2
New 2007 Sumifs formula - is there a new multiple criteria vlookup 2
If Formula When Contains Partial Word 5

Back
Top