Hello,
I initially posted this on an existing thread (https://www.mrexcel.com/board/threa...ence-within-a-text-string.892622/post-5878927), but was advised that my question differs from the original.
I have a list of file names (10 digit numbers) to look up against a list where these file names are embedded within a text. I was hoping to use VLOOKUP with TRUE as an argument to do relative referencing , but it didn't work. Is anyone able to provide a vb code for this lookup problem so that when the file number exists anywhere in the first column of the table array, it returns the file status, and returns blank or "NA" when it doesn't exist. I have attached a snapshot which shows the look up value and return value (which is what I need) on the left, and the lookup table on the right. Are you able to provide me with a vb code for this?
Thank you in advance
EDIT:
Left showing File Name (Lookup value), Return value (status) is on the right table. File numbers are embedded within text on the right table. used =VLOOKUP(A1, TABLE1,2,TRUE), but didn't work; returned #N/A for all loans whereas those numbers do exist on the right table.
I initially posted this on an existing thread (https://www.mrexcel.com/board/threa...ence-within-a-text-string.892622/post-5878927), but was advised that my question differs from the original.
I have a list of file names (10 digit numbers) to look up against a list where these file names are embedded within a text. I was hoping to use VLOOKUP with TRUE as an argument to do relative referencing , but it didn't work. Is anyone able to provide a vb code for this lookup problem so that when the file number exists anywhere in the first column of the table array, it returns the file status, and returns blank or "NA" when it doesn't exist. I have attached a snapshot which shows the look up value and return value (which is what I need) on the left, and the lookup table on the right. Are you able to provide me with a vb code for this?
Thank you in advance
EDIT:
Left showing File Name (Lookup value), Return value (status) is on the right table. File numbers are embedded within text on the right table. used =VLOOKUP(A1, TABLE1,2,TRUE), but didn't work; returned #N/A for all loans whereas those numbers do exist on the right table.
Last edited by a moderator: