| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP/OFFSET Problem
Hi all Have a huge worksheet and loads of dates and data. It is regarding stockmarkets and trading for my thesis. I am looking up dates and returning a value using a VLOOKUP formula =VLOOKUP(S2;LAIS2!$A$3:$G$438;7;FALSE) and it is working like it should. I am trying to find out trading dates before and after the value the VLOOKUP returns. I thought of using a OFFSET formula but that does not seem to work with the VLOOKUP. Does anyone understand what I am trying to do and able to help me? Regards, Vilhelm -- XavierXXX ------------------------------------------------------------------------ XavierXXX's Profile: http://www.excelforum.com/member.php...o&userid=28875 View this thread: http://www.excelforum.com/showthread...hreadid=486221 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| have some problem with database | Excel Discussion (Misc queries) | |||
| Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Threaded Mode
