Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 15th 15, 06:19 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: May 2015
Posts: 8
Default Using Vllookup with OFFSET or ???

I'm trying to create a "Rollup" sheet with information from 5 other TABs. The TAB data is based on (for the example below) being in a TAB named AG (which is in A5). So in TAB AG cell ref F5 is what I would like Vlookup to return. Here's where it get interesting. My Boss has added a drop down box with the beginning dates of a two week period which allows a user to pick (its cell link is in D42) 12/29/2014 which = 1, or Jan/12/2015 which =2 etc.. So what he is asking is:

If the user picks 12/29/2014 from the drop down list, the Vllookup formula returns from TAB AG F5,

If the user picks Jan/12/2015 from the drop down list, the Vllookup formula returns from TAB AG V5,

....and so on and so on. Any thoughts on using Vlookup/Offset or perhaps INDIRECT...
ColA B C D E F
AG J2 L Don AM SHIFT F5 is where I would like the formula

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet Howard Excel Programming 27 September 29th 13 09:20 PM
Take active cell value in for loop and offset based on another cellvalue for columns to offset burl_h Excel Programming 0 May 23rd 12 03:20 AM
Rather tired and need solution please 4 Vllookup :-D Les Stout[_2_] Excel Programming 7 April 19th 07 06:10 AM
Urgent problem with Vllookup Jeff Excel Discussion (Misc queries) 2 September 22nd 05 07:05 PM
VlLOOKUP function with MATCH Amnon Wilensky Excel Worksheet Functions 2 June 6th 05 07:38 PM


All times are GMT +1. The time now is 05:32 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017