One way

In your other sheet,
Assume Emp IDs are listed in B2 down

Put this in C2:
=IF(ISNA(MATCH(B2,Sheet1!B:B,0)),"",
INDEX(Sheet1!C:C,MATCH(B2,Sheet1!B:B,0)))
Copy C2 down as far as required

P/s: Do not use all caps in your posting, its tough to read
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---
"Srinivas" wrote:
Sheet 1 ...
A B C D E F
1 EMP NAME EMPID AMT
2 JOHN K-1234 5600
3 KITE K-1235 7000

I want in another sheet to take values in c1 to c100
if the emp id matches with sheet 1
it should take the values of "c" of that particular emp