Location Transport

How to get Excel to return the location of a piece of information?

I have an Excel spreadsheet, version 2003. I have a column of data in column Q. I want to see if any of the cell values in column match the cell values in column H. If it does, I want Excel to return the location of that cell. Anyone know how to do this?

Public Comments

1. This is a problem which I would solve with a formula constructed with 3 steps: Assume cell to check for matches is in Q1 and data to check is in cells H1 through H100. Step 1: Find if there is a match in column H. =MATCH(Q1,$H$1:H$100,0) (returns #N/A if there is no match and returns the place within H1:H100 of the cell which matches Q1 if there is a match) Step 2: Now "go to" that cell: =INDEX($H1:H$100, MATCH(Q1,$H$1:H$100,0)) (Now the formula from step 1 is used as the index in the reference range.) Step 3: Now grab the cell address of that cell: =CELL("address", INDEX($H1:H$100, MATCH(Q1,$H$1:H$100,0)) ) gives the "A1" type cell reference of the cell which matches Q1. Please note that if there is no match, you must add the appropriate error identifiers; For example, =IF(ISNA( formula ), "No Match", formula) Good Luck.