| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identify address of cell containing specific data
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Identify address of cell containing specific data
Another, similar way:
=ADDRESS(1,MATCH(G1,A1:D1,0)) that will return #N/A if G1 does not hold 1 of the 4 month names, you can deal with that with: =IF(ISNA(ADDRESS(1,MATCH(G1,A1:D1,0))),"",ADDRESS( 1,MATCH(G1,A1:D1,0))) or even tell when there's no match with that last one changed to =IF(ISNA(ADDRESS(1,MATCH(G1,A1:D1,0))),"No Match",ADDRESS(1,MATCH(G1,A1:D1,0))) "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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Identify address of cell containing specific data
Thanks - very useful
"JLatham" wrote: Another, similar way: =ADDRESS(1,MATCH(G1,A1:D1,0)) that will return #N/A if G1 does not hold 1 of the 4 month names, you can deal with that with: =IF(ISNA(ADDRESS(1,MATCH(G1,A1:D1,0))),"",ADDRESS( 1,MATCH(G1,A1:D1,0))) or even tell when there's no match with that last one changed to =IF(ISNA(ADDRESS(1,MATCH(G1,A1:D1,0))),"No Match",ADDRESS(1,MATCH(G1,A1:D1,0))) "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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to identify specific cells | Excel Discussion (Misc queries) | |||
| Data Validation: Store cell address instead of value in the cell? | Excel Discussion (Misc queries) | |||
| search column of text cellto identify those cells with specific w | Excel Worksheet Functions | |||
| How identify data of two coulams,Every cell count and show result | Excel Discussion (Misc queries) | |||
| identify data in a cell that has a number as the second character | Excel Worksheet Functions | |||
Linear Mode
