|Hi, I hope someone can help me with this.|
Please refer this spreadsheet.
In table 1, at functional role column (F7), there is list of functional role that I have to choose. At table 2 (AX6:DS25), I put this formula for cell AX9
so that when I choose the respective functional role, it automatically copied data from table 3 to table 2.
My question is, how can I combine formula so that I can choose another list (Specific position column (G7), so that the data from table 4 can be copied to table 2, based on the specific position i choose.
Please note that the row header is the same for table 2, table 3 and table 4.
I hope u guys can understand my question.\
Thanks in advance.