Identify address of cell containing specific data
try
="A"&match(G1,A1:A4)
as one way
"Peter N." wrote:
If range A1:D1 contains names of months January - April and G1 can be any
month, how can I find out the address of the cell containing the data that is
in G1? I use Excel 2000.
|