kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 923
- Office Version
- 365
Hi,
I have the following table:
In table 1, I have the policy no. I have another report in Table 2 which has the policy number within a string in the cell. Example, in cell J4, I have A45789J and in cell M6, we have PRMA45789J. I am trying to use a vlookup in column K to find a match from column M. As long as the value in column J exist within any of the string of values in column M, it should return the value in column K, otherwise to return as N/A.
Example of the correct results is in column K. Is there a way to modify the normal vlookup formula accommodate this ? Appreciate all the help.
I have the following table:
Book1 | ||||||
---|---|---|---|---|---|---|
J | K | L | M | |||
2 | Table 1 | Table 2 | ||||
3 | Policy No | Result | Report 1 | |||
4 | A45789J | A45789J | GHF4457IU | |||
5 | G44578A | N/A | RTAJ77876R | |||
6 | J77876R | J77876R | PRMA45789J | |||
Sheet1 |
In table 1, I have the policy no. I have another report in Table 2 which has the policy number within a string in the cell. Example, in cell J4, I have A45789J and in cell M6, we have PRMA45789J. I am trying to use a vlookup in column K to find a match from column M. As long as the value in column J exist within any of the string of values in column M, it should return the value in column K, otherwise to return as N/A.
Example of the correct results is in column K. Is there a way to modify the normal vlookup formula accommodate this ? Appreciate all the help.