I have two excel speadsheets. One with names and ID numbers. The other just
has some of the names in the first datasheet. The second speadsheet needs to
be updated with the ID numbers that corespond with the names in the first
spreadsheet. Is there a way of matching the names from the second sheet with
the first sheet and transferring the ID numbers from the first sheet to the
second sheet in one fell swoop without having to do it by hand? (There are
over 250 of them!)

Thanks for the assistance in advance.