| 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 |
| 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) | |||
Threaded Mode
