I'm using a vlookup formula and I'm looking for a way to use it to pull from a database where the reference cell is essentially changing from week to week. So, technically, it would be an unknown reference cell. Has anyone done this successfully? Any input would be greatly appreciated. Thanks!
vlookup question
- Thread starter JenniferK
- Start date
Brianwarnock
Retired
- Local time
- Today, 20:51
- Joined
- Jun 2, 2003
- Messages
- 12,667
If you don't know the reference cell how can EXCEL?
Brian
Brian
It is not possible as far as I know...
Work out some other way Jennifer....like, you can fix the reference each time at a regular intervalic gap...like if A1 today, then may be C1 tomorrow and E1 the day after tomorrow, etc...but make sure that if you are going to use such kind, then you have make the reference get changed in the formula also...
May you get a better solution...all the best..!!!
Work out some other way Jennifer....like, you can fix the reference each time at a regular intervalic gap...like if A1 today, then may be C1 tomorrow and E1 the day after tomorrow, etc...but make sure that if you are going to use such kind, then you have make the reference get changed in the formula also...
May you get a better solution...all the best..!!!
Brianwarnock
Retired
- Local time
- Today, 20:51
- Joined
- Jun 2, 2003
- Messages
- 12,667
I am going to guess that each week you know the reference of the reference cell but don't want to change the Vlookup, if this is the case then checkout Indirect and see if that will work for you
eg Vlookup((Indirect(A1),arrayname, etc)
Then you just type the reference into A1
eg T4 or Sheet1!F3
Brian
eg Vlookup((Indirect(A1),arrayname, etc)
Then you just type the reference into A1
eg T4 or Sheet1!F3
Brian
