CELL ADDRESS HELP

S

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.
 
S

Stan Brown

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.
Click to expand...

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

SDough

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)
 
Top