I have a problem that I need help with. In sheet 1 I have a list of 10 addresses. I need to see if a list on sheet 2 contains any combination of the same addresses, and put the cell address in a column on sheet 1.
For example:
In sheet 1, cell A1, I have '123 Main St.'
In sheet 2, there is a cell (say cell A789) that has '123 Main st. Floor 2'
I need to be able to have a formula that will search Column A on sheet 2, find and match '123 Main st. Floor 2', and return the cell address on Sheet 1, cell B1
I thought the formula below (entered into cell B1 on Sheet 1) would do it but it isn't working for me. It is entirely possible that I am not using the INDEX & MATCH formulas correctly.
=CELL("address",INDEX(Sheet1!$A$1:$S$8,MATCH("*"&A1&"*",Sheet1!$A$1:$S$8,0)))
Any help that you can offer would be GREATLY appreciated. Let me know if you have any questions.
Thank you in advance,
John
For example:
In sheet 1, cell A1, I have '123 Main St.'
In sheet 2, there is a cell (say cell A789) that has '123 Main st. Floor 2'
I need to be able to have a formula that will search Column A on sheet 2, find and match '123 Main st. Floor 2', and return the cell address on Sheet 1, cell B1
I thought the formula below (entered into cell B1 on Sheet 1) would do it but it isn't working for me. It is entirely possible that I am not using the INDEX & MATCH formulas correctly.
=CELL("address",INDEX(Sheet1!$A$1:$S$8,MATCH("*"&A1&"*",Sheet1!$A$1:$S$8,0)))
Any help that you can offer would be GREATLY appreciated. Let me know if you have any questions.
Thank you in advance,
John
