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

Try this:

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


--
Biff
Microsoft Excel MVP


"DavidMM" <(E-Mail Removed)> wrote in message
news:AC87B9FC-77EF-4675-A7EF-(E-Mail Removed)...
> =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.
>