LOOKUP

[Srinivas]

Sir,

Can i get another formula

SHEET 1 I HAVE EMPL DETAILS
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

REGARDS

SRINIVAS

 

[Max]

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