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

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

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

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

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

Hi,

Try this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"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

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

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

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

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
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

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

Thanks...It worked

"Rick Rothstein" wrote:

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

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

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
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