Hi. I'm new to the forum and somewhat of a novice.
I have two spreadsheets: Sheet1) has number(s) in column A and a name of a person associated with it in Column B.
Sheet2) has a list of numbers (Column A)that I want to cross reference with the names in Sheet1.
I want to run a vlookup in Sheet2 B2 to find the Exact (FALSE) match on Sheet1 and return the name associated with it.
The problem I'm running into is that for the cells in Sheet1 Col A that have multiple numbers (separated (Alt+Enter) ) I keep returning an #N/A. I can find these numbers using the FIND function.
The cells that only have one number come back fine.
Appreciate it if someone knows anything about this. Thanks
I have two spreadsheets: Sheet1) has number(s) in column A and a name of a person associated with it in Column B.
Sheet2) has a list of numbers (Column A)that I want to cross reference with the names in Sheet1.
I want to run a vlookup in Sheet2 B2 to find the Exact (FALSE) match on Sheet1 and return the name associated with it.
The problem I'm running into is that for the cells in Sheet1 Col A that have multiple numbers (separated (Alt+Enter) ) I keep returning an #N/A. I can find these numbers using the FIND function.
The cells that only have one number come back fine.
Appreciate it if someone knows anything about this. Thanks
