How can I use OFFSET and VLOOKUP together

[DavidMM]

=OFFSET(F16,-1,0,1,1), Instead of using a cell reference I want to use a
VLOOKUP to reference a cell, like this,
=OFFSET(vlookup(D19,A3:A28,1,false),-1,0,1,1).

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

A
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.

 

[T. Valko]

Try this:

=INDEX(A3:A28,MATCH(D19,A3:A28,0)-1)