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!

If you don't know the reference cell how can EXCEL?

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..!!!

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