Forum Discussion
LAB14086
May 06, 2022Copper Contributor
Matching Single Accounts and Shared Accounts
I have a single spreadsheet with individual rows of data representing one person. They also have a spouse somewhere in the spreadsheet in a separate row. There are two different kinds of ID numbe...
HansVogelaar
May 06, 2022MVP
Assuming that IndivID is in column B and SharedID in column C, starting in row 2, enter the following formula in the first available column in row 2:
=IFERROR(INDEX($B$2:$B$101,MATCH(1,($C$2:$C$101=C2)*($B$2:$B$101<>B2),0)),"")
Modify the ranges if you have more than 100 rows of data.
If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter.
Then fill or copy down.