Results 1 to 2 of 2
2001-08-15, 01:53 #1
- Join Date
- Apr 2002
- Thanked 0 Times in 0 Posts
Cell References & External Links (Excel 97 for Windows)
Long time no post, but here's an interesting one. Sure there's an easy way, but it seems to be escaping me at the mo : (
Is it possible to nest a cell reference into an external reference?
I have an external file ABC.xls, with sheets named Wk1 through Wk 10.
On the report sheet I have a a column with Wk1 through Wk10. Lets call this range $XX$1:$XX$10
I want to use a vlookup formula to obtain information from a given cell, say $A$1, on each sheet (Wk1 through Wk10) on the external file, however being a really lazy proponent of the 'click and drag' mentality, I want refer to the external sheet by way of the column. So . . .
Where $XX$1 relates to the cell containing "Wk1".
However, l've gotta feeling that there's some type of syntax missing which would indicate that my sheet_reference is actually a cell not the external sheet reference itself.
Clear as mud?
Any ideas out there?
2001-08-15, 08:11 #2
- Join Date
- Dec 2000
- Burwash, East Sussex, United Kingdom
- Thanked 206 Times in 190 Posts
Re: Cell References & External Links (Excel 97 for Windows)
If you just want the value of a particular cell you don't need vlookup at all. You could just use something like:
unless I've totally misunderstood you!
Does that help?Regards,
Microsoft MVP - Excel