Hi @manjesh_kumar,
One possible solution could be to copy & apply the solution created by you on a different column, and afterwards check the result.
It could be a series of vlookups, or you can use some kind of flowchart for efficiency, for instance:
VLOOKUP_Check_Column1 —> Result 1
If Result 1 is Nothing, then
VLOOKUP_Check_Column2 —> Result 2
If Result 2 is Nothing, then … and so on
Hope this helps.
Best regards,
Marius