Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, =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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
offset within vlookup | Excel Discussion (Misc queries) | |||
offset off a vlookup? | Excel Discussion (Misc queries) | |||
Offset VLookup | Excel Worksheet Functions | |||
vlookup and offset | Excel Worksheet Functions | |||
Vlookup is not enough ... can OFFSET be used ? | Excel Worksheet Functions |