Multiple Table Link

[Justin_T]

Hello!

Thank you guys/gals for taking the time to view this post.

I am looking at creating a custom generator based on 3 criteria I give it.

The first Criteria will lookup in Table_1, Find the corresponding data which will give it the next table link.

From there it will use the 2nd piece of data to pick a process, which will populate a form.

The third piece will simply pick the data from a third table and place it in 3 different spots(This is the easy one).

If I need a better format or what have you, This is my first time posting on a forum like this!

Thanks a lot!

Justin T

It Should look like this.


TABLE_1
A | 1
B | 2
C | 3

If A3 = A Then Display 1, Goto Table labeled 1
Search Table 1 for Process A
Display Process A in a Form

Search Table 3 for D3
Place Value from Table 3 to A27,B27,E27

 

[Justin_T]

I forgot one thing. I am using Office 365, But the formulas need to be compatible with office 2013 as the document will be saved in that format.

 

[nick12]

Have a table with 8 columns... Need for find name in column 2 when ranking in column 8 is #1 ...column 8 has multiple rankings of #1 but name specific only in column 2