Sounds like you need the vlookup( ) function.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Alexandra Lopes" wrote:

Hello,


I have a list of projects with the different assignments that each one
can have. For example:

Project Assignemt1 Assignemt2 Assignemt3

A AA A1 ACA
B BBB BBo3 BBC
C COC C410 CT
D D345 d DSi

In others sheets I have values for each assignments. And I intend, for
example, to make a research for project A that it returns the value that
this has in the sheet where it calls A1.


Thanks in advance.