retrieving values from a certain column

[Osmario.Avila]

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

 

[Claus Busch]

Hi Osmario,

Am Tue, 23 Oct 2012 10:01:27 -0700 (PDT) schrieb
(e-mail address removed):

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

 

[Osmario.Avila]

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

(e-mail address removed):








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