| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
retrieving values from a certain column
Hi
In column B a have a list of 160 labors. In column A I have 160 values belong to the names showed in column B. Each labor showed in column B has his your own value corresponding in column A. I need to force excel shows the correspondig value in Column C every time I enter name in column D. 160 John 527 Grieg 433 Paul 982 Mary 527 Grieg 444 Anton Is this possible? Thanks in advance Osmario |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
retrieving values from a certain column
Hi Osmario,
Am Tue, 23 Oct 2012 10:01:27 -0700 (PDT) schrieb : In column B a have a list of 160 labors. In column A I have 160 values belong to the names showed in column B. Each labor showed in column B has his your own value corresponding in column A. I need to force excel shows the correspondig value in Column C every time I enter name in column D. 160 John 527 Grieg 433 Paul 982 Mary 527 Grieg 444 Anton in C1: =INDEX(A:A,MATCH(D1,B1:B200,0)) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
retrieving values from a certain column
Em terça-feira, 23 de outubro de 2012 15h33min13s UTC-2, Claus Busch escreveu:
Hi Osmario, Am Tue, 23 Oct 2012 10:01:27 -0700 (PDT) schrieb : In column B a have a list of 160 labors. In column A I have 160 values belong to the names showed in column B. Each labor showed in column B has his your own value corresponding in column A. I need to force excel shows the correspondig value in Column C every time I enter name in column D. 160 John 527 Grieg 433 Paul 982 Mary 527 Grieg 444 Anton in C1: =INDEX(A:A,MATCH(D1,B1:B200,0)) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 Hi Claus That's fantastic - thanks a lot Osmario |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| retrieving multiple corresponding values with variable rows/column | Excel Worksheet Functions | |||
| Help with Comparing values and retrieving values in Excel!!!!!! | Excel Worksheet Functions | |||
| retrieving values from a specified sheet | Excel Worksheet Functions | |||
| Retrieving VLookup Values | Excel Programming | |||
| Help Retrieving Cell Values | Excel Programming | |||
Linear Mode
