How can I use OFFSET and VLOOKUP together



=OFFSET(F16,-1,0,1,1), Instead of using a cell reference I want to use a
VLOOKUP to reference a cell, like this,

What I am actually trying to do is return a value from a cell before the
VLookup value.

1 Wednesday, 9 April 2008
2 Thursday, 10 April 2008
3 Friday, 11 April 2008
4 Monday, 14 April 2008
5 Tuesday, 15 April 2008
6 Wednesday, 16 April 2008
7 Thursday, 17 April 2008

My Vlookup, will find Tuesday for me, but I actually want the data from the
Monday before the found date.


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