Cross Referencing

Hi. I'm currently crossreferencing data on two spread sheets and wondered if there was a quicker way to do it!

On the master spreadsheet, I have employee names in the first column, and their employee number next to them.

The second is employee numbers logging in and out of the building within a specified time period, so with columns of number, time in/out. It's over a few months, so the employee numbers repeat a lot.

I need to put the names next to the relevant employee numbers for the second sheet. Is there a way of doing this through a formula?

Hi and welcome to the board

Have a look at the VLOOKUP formula

Hi and welcome to the board

Have a look at the VLOOKUP formula