retrieving values from a certain column

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
 
C

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
 
O

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top