Search a name in one sheet and entry it into another sheet

[Shilpi]

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

 

[Rick Rothstein]

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)

 

[Ashish Mathur]

Hi,

Try this

=VLOOKUP(C6,Sheet1!$D$10:$E$15,2,0)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Rick Rothstein]

Sorry, I left out some absolute cell references...

=INDEX(Sheet1!A$2:B$6,MATCH(A2,Sheet1!A$2:A$6,0),2)

 

[Shilpi]

Thanks...It worked

Sorry, I left out some absolute cell references...

=INDEX(Sheet1!A$2:B$6,MATCH(A2,Sheet1!A$2:A$6,0),2)