| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search a value in W/sheet | Excel Discussion (Misc queries) | |||
| Search for rows in one sheet and copy into another sheet based on customer id | Excel Worksheet Functions | |||
| repeat an entry on spread sheet | Excel Worksheet Functions | |||
| repeat an entry on spread sheet | Excel Worksheet Functions | |||
| Search for a Sheet | Excel Discussion (Misc queries) | |||
Linear Mode
