retrieving values from a certain column

  • Thread starter Thread starter Osmario.Avila
  • Start date Start date
O

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
 
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
Click to expand...

in C1:
=INDEX(A:A,MATCH(D1,B1:B200,0))


Regards
Claus Busch
 
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
Click to expand...

Hi Claus

That's fantastic - thanks a lot
Osmario
 
Back
Top