The Vlookup can be combined with other formulas but not for ranges so if I understand right this can be done in 1 of 2 ways.
VBA or making another column of data to make the vlookup work.

Since we are on the Excel forum I will show you how you can do this by making another column.

On Tab 1 you will need to insert a column to the left of A. This will push your original data to column B. Now write the formula in cell A2
and drag that all the way down. Now this is assuming that all of your employee numbers are 5 characters. It that is not the case it is certainly possible to write a combination of mid and search formulas to extract out the number but I personally would just do it in VBA.

After you have this column you can then use your vlookup to pull the data that you need. Remember the + 0 so can you convert the mid text value into a number or the vlookup will not work.


If anyone has a different approach to do this with formulas I would love to see it since I've already done quite a few experiments to grab it and they havent worked.

Thanks