I have the list of data in two different worksheets.
First sheet is something like this
And second sheet is something like below
I would like to use vlookup to get ID from table2 to table1. Is it possible to ask excel to cheek if any values in the table1 are very much similar to the any values in the table2 then start vlookup?
Thanks you very much for your time. Your comment will be very much appreciated.