Hi:
I have 2 spreadsheets that have some of the same info as well as different data. Doc A contains Employees Name and ID number (20 000 Rows) and Doc B contains Employee ID, Name and Work Location. What I am trying to do is SET UP SOME TYPE OF FORMULA THAT WILL HAVE DOC 1 LOOK AT DOC 2 AND ONCE IT FINDS THE EMPLOYEES ID NUMBER FROM THE LIST IN DOC 2 IT WILL PUT THE ID NUMBER INTO DOC 1. i have played around a bit but can't seem to figure it out. It is definately not a simpple cut and paste procedure. Does anyone know hwo I can accompliish my task? Any help would be appreciated.
Thanks,
Mark
I have 2 spreadsheets that have some of the same info as well as different data. Doc A contains Employees Name and ID number (20 000 Rows) and Doc B contains Employee ID, Name and Work Location. What I am trying to do is SET UP SOME TYPE OF FORMULA THAT WILL HAVE DOC 1 LOOK AT DOC 2 AND ONCE IT FINDS THE EMPLOYEES ID NUMBER FROM THE LIST IN DOC 2 IT WILL PUT THE ID NUMBER INTO DOC 1. i have played around a bit but can't seem to figure it out. It is definately not a simpple cut and paste procedure. Does anyone know hwo I can accompliish my task? Any help would be appreciated.
Thanks,
Mark