Two things, at least, you are doing wrong.

Firstly your caps lock key is broken so you are SHOUTING at us.
Secondly, it looks as if you are getting confused between text strings and
cell references. ADDRESS returns a text string, but the CELL function is
looking for a cell reference. =CELL("contents",$J$1594) would be valid but
=CELL("contents","$J$1594") would not.

You probably want the INDIRECT function, rather than the CELL function. But
aren't you going round the houses? MATCH returns a position in an array,
ADDRESS converts that to text, INDIRECT converts the TEXT back to the
content of a cell. Wouldn't it be better to use a lookup function to get
the data directly?
--
David Biddulph

"heather" wrote in message
...
TRYING TO REFENCE A CELL IN ANOTHER WORKBOOK. TO GET TO THAT I USED
=ADDRESS(MATCH(I30,'[Vendor sales at cost.xlsx]Sheet1'!$I:$I,0),9)),0,1))
WHICH GIVES ME $J$1594
I WANT IT TO RETURN THE ACTUALL DATA THAT IS IN THAT CELL...HOW CAN I DO
THIS? I HAVE TRIED USING =CELL("CONTENTS",FORMULAFROMABOVE) BUT THAT
RETURNS
AN ERROR...WHAT AM I DOING WRONG?