| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Functions
Hi Guys I need a function or a formula which can do the following...... I have two worksheets. One worksheet has a list of names in a set order that can't be changed. The other worksheet has the same list of names in alpabetical order with a value next to the name in a seperate column. I need to grab the value from the second sheet and insert it next to the same name in the first sheet.. I hope that made sense Thanks in advance Digital -- digital21st ------------------------------------------------------------------------ digital21st's Profile: http://www.excelforum.com/member.php...o&userid=29575 View this thread: http://www.excelforum.com/showthread...hreadid=561970 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Functions
digital21st wrote: Hi Guys I need a function or a formula which can do the following...... I have two worksheets. One worksheet has a list of names in a set order that can't be changed. The other worksheet has the same list of names in alpabetical order with a value next to the name in a seperate column. I need to grab the value from the second sheet and insert it next to the same name in the first sheet.. I hope that made sense Thanks in advance Digital -- digital21st ------------------------------------------------------------------------ digital21st's Profile: http://www.excelforum.com/member.php...o&userid=29575 View this thread: http://www.excelforum.com/showthread...hreadid=561970 Hi, It sounds like you can use VLOOKUP() Something like: =VLOOKUP(NameInSheet1,ArrayOfNamesAndValuesOnSheet 2,2,False) So maybe like: =VLOOKUP(A1,Sheet2!$A$1:$B$10,2,FALSE) And copy down next to your list of names on Sheet1 Regards, Bondi |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Functions
=VLOOKUP(A1,Sheet2!$A$1:$B$10,2,FALSE)
copy down. "digital21st" wrote in message ... Hi Guys I need a function or a formula which can do the following...... I have two worksheets. One worksheet has a list of names in a set order that can't be changed. The other worksheet has the same list of names in alpabetical order with a value next to the name in a seperate column. I need to grab the value from the second sheet and insert it next to the same name in the first sheet.. I hope that made sense Thanks in advance Digital -- digital21st ------------------------------------------------------------------------ digital21st's Profile: http://www.excelforum.com/member.php...o&userid=29575 View this thread: http://www.excelforum.com/showthread...hreadid=561970 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Functions
Cheers Bondi It worked a treat. Regards Digital -- digital21st ------------------------------------------------------------------------ digital21st's Profile: http://www.excelforum.com/member.php...o&userid=29575 View this thread: http://www.excelforum.com/showthread...hreadid=561970 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Functions in Excel | Excel Worksheet Functions | |||
| How do I see the formula calculation used in Excel functions box | Excel Worksheet Functions | |||
| Improved Excel functions curve fitting in sheet | Excel Worksheet Functions | |||
| Are there functions that perform robust statistics in Excel? | Excel Worksheet Functions | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Linear Mode
