CELL ADDRESS HELP
 

I've used the DGET function to lookup a value in a datasheet; however, I
can't find a way to determine the CELL ADDRESS of the data corresponding to
the lookup.

CELL ADDRESS HELP
 

Mon, 14 May 2007 20:51:01 -0700 from SDough
:
I've used the DGET function to lookup a value in a datasheet; however, I
can't find a way to determine the CELL ADDRESS of the data corresponding to
the lookup.

The MATCH function tells you where the value is located in the array.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

CELL ADDRESS HELP
 

The MATCH function tells me where the first instance of a match occurs. If
my data contains multiple instances (For Example, $20), it won't necessarily
return the correct location of the $20 which matches a set of criteria (like
a specific date, time, etc)

"Stan Brown" wrote:

Mon, 14 May 2007 20:51:01 -0700 from SDough
:
I've used the DGET function to lookup a value in a datasheet; however, I
can't find a way to determine the CELL ADDRESS of the data corresponding to
the lookup.

The MATCH function tells you where the value is located in the array.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/