DISPLAY A RESULT

[bookman3]

hI

Cell B1 displays the answer $B$200 which is the correct result of a formula.
In cell C1 I now need to display the contents of cell C200.
How cabn I achieve this?

 

[Max]

Venturing a guess that you really meant

Display the cell contents of the cell ref
returned by the formula that you have in B1
(eg it's returned in B1 as say: B200)

Then in C1: =IF(B1="","",INDIRECT(B1))
will return the contents of the cell ref in B1, ie: B200

P/s: think there was typo in your post when you said "C200"
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik

 

[bookman3]

Hi

Actually there wasn't a typo.
Maybe I need to be morer explicit.
This is a simplified example of what I am trying to do

Say range A3:A6 Displays 1st Jan to 4th Jan
and Range B3:B6 Displays the values 1,2,3 and 4 in that order.

In cell B1 I am now displaying the result $B$6 which is the max.
In cell A1 I now want to display the date of the maximum result.

 

[Max]

In A1: =INDEX(A3:A6,MATCH(B1,B3:B6,0))
Format A1 as date to taste

Should there be ties in the max value within B3:B6, then A1 will return the
1st match, ie the date higher up within A3:A6
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik