Hello,friends!
I need to extract region from Table 1 to Table 2 only by criteriums (PROJECT) in Table 3 . I tried INDEX/MATCH by name, but it returns me the first value which it finds.
Thanks in advance!
I need to extract region from Table 1 to Table 2 only by criteriums (PROJECT) in Table 3 . I tried INDEX/MATCH by name, but it returns me the first value which it finds.
Thanks in advance!
| REGION | NAME | PROJECT | REGION | NAME | PROJECT | REGION | PROJECT |
| COL | ACHCHEY LAL | WIN | ACHCHEY LAL | TEN | COL | TEN | |
| COL | ACHHE LAL PRAJAPATI | WIN | ACHHE LAL PRAJAPATI | ELE | AUT | ELE | |
| AUT | AKHILESH KUMAR | WIN | |||||
| AUT | DIMPLE MASIH | WIN | Table 2 | Table 3 | |||
| COL | MALKIT SINGH | WIN | |||||
| COL | ACHCHEY LAL | TEN | |||||
| AUT | ACHHE LAL PRAJAPATI | ELE | |||||
| Table 1 |
In Table 1 there are a plenty of data(Names,passport numbers,regions and projects),and in the Table 2 is small part which is in some cases duplicated in Table 1..The only difference is that in Table 1 the regions and projects are different for the same people.Only duplicated are names or passport numbers.And I woud like to get the aproppriate region from table 1,by name(or passport number) only by project in Table 3,and when it when it comes to a certain man and the asked project is not what I need,it should skip it.If thats the only time when man is in Table 1 it shoud return error(just like it didnt found him) .But in table 3 one region have 3 or more projects.
