diferent names

[Alexandra Lopes]

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.

 

[Gary Brown]

Sounds like you need the vlookup( ) function.

 

[Alexandra Lopes]

Yes, It does.

Thanks.