Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to find out a formula to match Reg No. for two workbooks. First work book is a master book I update everyday almost, next workbook I have employees name and ID numbers only, nos are in different cells than worksheet one. I want to get master file Reg no. to match the other work book and copy the birth dates. Basically both workbooks reg. no. to be match and add only b day to another colom.

workbook1 , A3:A200=Reg no. and L3:L200= birthdays workbook2, A3:A200=Reg no. and I want get birthday from other workbook to J:3:200

share|improve this question

Look up the HLOOKUP function. :-)

J3:J200 shall have something like (take it with a grain of salt, i cannot check the precise syntax right now, maybe later):

=HLOOKUP(A3,workbook1!A3:A200,false)

http://office.microsoft.com/en-001/excel-help/hlookup-HP005209114.aspx

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .