Assuming the COMBINED NAME's are in Column A on both sheets and the AUTHOR
ID's are in Column B on both sheets, put this formula B2 on Sheet2 and copy
it down...

=INDEX(Sheet1!A2:B6,MATCH(A2,Sheet1!A2:A6,0),2)

--
Rick (MVP - Excel)


"Shilpi" wrote in message
...
In one sheet (Sheet 1)i am having the Author names in one column with
their
Author ID's in another column of the same sheet.In another sheet (Sheet
2)i
am having the Author name with their other details. Now, I wish to put the
Author ID into the other sheet 2 which has other details too..
For eg.
SHEET 1:
COMBINED NAME AUTHOR ID
AKUMU C101765
ALACID M D12345
GIDLEY J c3455
GOGGIN G C45678
MARTIN F C34566

SHEET 2:
COMBINED NAME AUTHOR ID

GIDLEY J
MARTIN F
GOGGIN G

I have tried Vlookup But its not working...Its always coming REF,N/A,
VALUE?

Can anybody help me please.
Thanks a lot