Data on main page

    Hi,



    I am looking for a formula which show data on my main page as per selection on I3 and I6.



    We have 3 different regions and 11 departments.



    So on main page if we select IND and ABC then formula should display data for ABC for ss,aa,nn and gg.



    Every thing else is formula based, we need only these 4 fields to be filled up.



    Thank you for taking time to study it.

    Use VLOOKUP with INDIRECT, e.g., in cell J8:

    Code
    =VLOOKUP(I8,INDIRECT($I$3&"!"&IF($I$6="ABC","D6:E7",IF($I$6="BGD","J6:K7",IF($I$6="CFD","P6:Q7",IF($I$6="FGH","V6:W7",IF($I$6="BHG","AH6:AI7",IF($I$6="NBD","AN6:AO7",IF($I$6="VFD","AT6:AU7",IF($I$6="ASE","AZ6:BA7",IF($I$6="CDX","BF6:BG7",IF($I$6="POI","BL6:BM7"))))))))))),2)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login