Hi All,

In one sheet I have names. for example - Michael Jackson and then some
information in the rest of the columns. In the other sheet I have the IDs
which is first initial and the last name without space. Example - MJACKSON.
I need to use VLOOKUP but i need to find this ID in the names and then
return the values from rest of the columns.

Thanks for any help.