offseting formula

  • Thread starter Daniel Bonallack
  • 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
 

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

VBA Coding Help for Beginner 0
Vlookup to reference offset 1
What is the "--" (double dash) in MS Excel formula? 2
Sliding Commission Formula 2
Copy addition formula of non-consecutive horizontal cells 2
VLOOKUP & Data Validation 0
Pivot Table Calculated Field 0
Auto Fill Word Documents 4

Top