I am not sure if this can be done in Excel as it is a bit tricky, but let me ask.
Each cell in a column in spreadsheet "M" contains a unique number. If a cell in a column in a separate spreadsheet "D" holds a number that matches one of those unique numbers in spreadsheet "M", I want to set a True condition in an adjacent column in spreadsheet "M" to record that a relationship exists in the other spreadsheet.
I need to run this multiple times with different "D" spreadsheets that have different numbers of rows.
I appreciate any suggestions as to how I might accomplish this!!!
Bruce
Each cell in a column in spreadsheet "M" contains a unique number. If a cell in a column in a separate spreadsheet "D" holds a number that matches one of those unique numbers in spreadsheet "M", I want to set a True condition in an adjacent column in spreadsheet "M" to record that a relationship exists in the other spreadsheet.
I need to run this multiple times with different "D" spreadsheets that have different numbers of rows.
I appreciate any suggestions as to how I might accomplish this!!!
Bruce