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. |
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. |
All times are GMT +1. The time now is 01:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com