vlookup copy down

D

Davidm

Is there any way when copying a vlookup formula or similar to have the row of
the range change for example suppose you have a formula
=VLOOKUP($C$3,summary,3,FALSE)
and you want to copy down to cell below so formula is
=VLOOKUP($C$3,summary,4,FALSE)
and keep on going so when you copy down next the 4 changes to a 5 etc.

Thanks Dave
 
D

Davidm

thanks it answered my question well
Luke M said:
Try this:
=VLOOKUP($C$3,summary,ROW(A3),FALSE)

Now when you copy down, the A3 will change to A4, and cause the ROW function
to return a value of 4.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
 

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

Top