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

  • Thread starter Thread starter Shilpi
  • Start date Start date
S

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
 
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)
 
Sorry, I left out some absolute cell references...

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