| View previous topic :: View next topic |
| Author |
Message |
question4u
Newbie
Joined: 22 Feb 2011
Posts: 3
|
 Posted: Tue Feb 22, 2011 2:48 pm Post subject: *****Solved*****Searching for identical cell in two Columns? |
 |
|
Column A has a list of 20,000 names (Text and numeric combined)
Column B has a list of 5,000 names ((Text and numeric combined)
What I would like do s to search each name in Column B to Column A for IDENTICAL match and to display the cell address in Column C directly to the cell right of it.
Example:
A.......B .....C
44.....4
2.......D4
2K....1F
72....44
After running the command/formula in the spreadsheet it would look like this:
A.......B .....C
44.....4
2.......D4
2K....1F
72....44... ..A1
Row A1 cell contains 44
Row B4 cell contains 44
Match so cell C4 contains A1 (the address of the match)
There can be no more then one match so overwrite is not a problem.
I have looked at lookuo, match, index, conditional formatting.
I need "Answer for dummies" type response.
TY
Last edited by question4u on Thu Feb 24, 2011 11:56 am; edited 5 times in total |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Tue Feb 22, 2011 3:41 pm Post subject: |
|
|
D1 =N(MATCH($B1;$A$1:$A$xxx;0))
where xxx is the last row.
Copy D1 until the last row.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
question4u
Newbie
Joined: 22 Feb 2011
Posts: 3
|
| Posted: Tue Feb 22, 2011 5:28 pm Post subject: |
|
|
| Villeroy wrote: | D1 =N(MATCH($B1;$A$1:$A$xxx;0))
where xxx is the last row.
Copy D1 until the last row. |
I should go back to those blogs and articles that tried to explain this and post this in each one.
Sanity at last!
Thanks Villeroy!!!! |
|
| Back to top |
|
|
|
