Is there easier way to match data?

  • Thread starter Thread starter singkit
  • Start date Start date
S

singkit

Hello,

Any =body can help me. I want to know if there is easier
way to match data into different sheet. For example:
Sheet 1 contains employee number and employee tin no.,
Sheet 2 contains only employee number. I have to put
their corresponding tin number on sheet 2. They have no
exact number of records so it's difficult even you sort
it, I manually checking it and copy and paste. Is there
an easy way?
Please help.

thanks,
singkit
 
Hi

p.e. for cell B2 on sgeet2, with employee number in A2, and employee numbers
and tin numbers on sheet1 in range A2:B100, the formula will be
=VLOOKUP(A2,Sheet1!$A$2:$B6100,2,FALSE)
 
Hi
put the following in sheet two (assumption employee numbers are in
column A)
=VLOOKUP(A1,'sheet1'!$A$1:$B$1000,2,0)
and copy this down
 
Thank you so much. Really a great help :)
-----Original Message-----
Hi

p.e. for cell B2 on sgeet2, with employee number in A2, and employee numbers
and tin numbers on sheet1 in range A2:B100, the formula will be
=VLOOKUP(A2,Sheet1!$A$2:$B6100,2,FALSE)


--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets





.
Click to expand...
 
Back
Top