Re: Lookin up within a cell

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: dvinds (dvinds.1bmdi6_at_excelforum-nospam.com)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 18:40:56 -0500

Indirect did work.....thanks for that.
It wasn't what I was first thinking of, however,
It worked by putting the main reference *** in a1,a2,a3 & a4 and the
second constant reference in cells on the same page.
=INDIRECT("'" &$A$1& $B$2)
eg:
a1 = 'BAS 1 ''02-''03'! (page name) Changeable
b1 = $j$3 (cell reference)
b2, b3 and so on and so on.
This is probably what you meant in your replies, I just couldn't quite
see it at first.
Thanks again, I really appreciate it. 

---
Message posted from http://www.ExcelForum.com/
Quantcast