View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stan Brown Stan Brown is offline
external usenet poster
 
Posts: 524
Default 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/