apexRaiden
New Member
- Joined
- Oct 7, 2021
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
Good day,
I am trying to formulate a process where I can do a lookup or a search of ANYTHING within a cell and see if it exists in a column of entries.
The cell in question has a few lines of data but specifically has a line of data that could either have 1 entry or multiple entries that are separated by commas. I am trying to find a way to look for THOSE entries are within the column of data/entries to see if they match/exist. My end goal is to then say that if this does exist in column, then populate the rest of this entries details that are on another sheet. Almost as a IF TRUE THEN = 2ndSheet CELL DATA.
I know this formula doesn't work, but I hope it helps in the sense of explanation
=vlookup("*"&B2&"*",A:A,1,FALSE)
Again, I understand that this doesn't work, but I am just trying to help paint a picture of what im trying to obtain.
Is ANYTHING within THIS CELL over here in this column of entries?
Thank you!
I am trying to formulate a process where I can do a lookup or a search of ANYTHING within a cell and see if it exists in a column of entries.
The cell in question has a few lines of data but specifically has a line of data that could either have 1 entry or multiple entries that are separated by commas. I am trying to find a way to look for THOSE entries are within the column of data/entries to see if they match/exist. My end goal is to then say that if this does exist in column, then populate the rest of this entries details that are on another sheet. Almost as a IF TRUE THEN = 2ndSheet CELL DATA.
I know this formula doesn't work, but I hope it helps in the sense of explanation
=vlookup("*"&B2&"*",A:A,1,FALSE)
Again, I understand that this doesn't work, but I am just trying to help paint a picture of what im trying to obtain.
Is ANYTHING within THIS CELL over here in this column of entries?
Thank you!