Forum Discussion

PRASHANT RAWAT's avatar
PRASHANT RAWAT
Copper Contributor
Jul 17, 2018
Solved

dynamic formula

Hello team, I need the solution in attached sheet. As I have the four table which contains the employee's details like the product, date of joining month, Designation and employee Id and the ba...
excel
Excel Online
Formulas and Functions
  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    Jul 17, 2018

    "It's not working" is not good enough. Do you get an error or a wrong result? Have you applied the formulas correctly? 

     

    I have not changed column order or renamed any columns and it's working perfectly fine for me with the approach I posted above.

     

    E13 =INDEX(Empl,MATCH(B13,$B$3:$B$8,0))

    C13 =INDEX($E$3:$E$8,MATCH($E13,$D$3:$D$8,0))

    D13 =INDEX($H$3:$H$8,MATCH($E13,$G$3:$G$8,0))

    F13 =INDEX($H$3:$H$8,MATCH($E13,$G$3:$G$8,0))

     

    Copy row 13 formulas down. See attached file.

     

    If that is not working for you, please post your workbook with the formulas applied.

     

     

PRASHANT RAWAT's avatar
PRASHANT RAWAT
Copper Contributor
Jul 17, 2018
Q1. Please lookup the values by employee name in desired table and design dynamic formula so that we can change the Header.
Don’t change the sequence of questioning table.
IngeborgHawighorst's avatar
IngeborgHawighorst
MVP
Jul 17, 2018

"It's not working" is not good enough. Do you get an error or a wrong result? Have you applied the formulas correctly? 

 

I have not changed column order or renamed any columns and it's working perfectly fine for me with the approach I posted above.

 

E13 =INDEX(Empl,MATCH(B13,$B$3:$B$8,0))

C13 =INDEX($E$3:$E$8,MATCH($E13,$D$3:$D$8,0))

D13 =INDEX($H$3:$H$8,MATCH($E13,$G$3:$G$8,0))

F13 =INDEX($H$3:$H$8,MATCH($E13,$G$3:$G$8,0))

 

Copy row 13 formulas down. See attached file.

 

If that is not working for you, please post your workbook with the formulas applied.

 

 

Resources