View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default How can I use OFFSET and VLOOKUP together

Try this:

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


--
Biff
Microsoft Excel MVP


"DavidMM" wrote in message
...
=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.