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