Hello,
I am wondering if there is anyway to find a matching of a single value from another cell that may have multiple values that are separated by commas.
For example, can some tool like VLookup find a match for '3' (Sheet 1/Column B/Row 1) from Sheet 2?
Sheet 1
Column A Column B
1 Name A 3
2 Name B 5
3 Name C 6
4 Name D 7
Sheet 2
Column A Column B
1 Name A 1, 2, 3
2 Name B 4, 5
3 Name C 006
4 Name D 7, 8
If I need to provide more explanation, please let me know.
You don't say what value you want returned...I'll assume you want the Sheet2 Name associated with the Sheet2 Col_B cell that contains the value you want to find.
If that's true...Using your posted scenario, try this on Sheet1:
Please Login or Register to view this content.
In your example, the formula returns: Alpha
If you want it to return the cell contents of the Sheet2 cell that contains the value you're looking for:
Please Login or Register to view this content.
In that case, the formula returns: 1,2,3
Is that something you can work with?
Wow.... thank you, Ron! This is exactly what I was looking for. Thank you so much!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks