Formula to auto populate the numbers in attached sheet

[Rameez Sarang]

Hi,
I am working on the attached sheet and looking for a formula or solution which would auto populate the values in the table once I select the rank.
For e.g: if I enter rank 1, it should show all the Carrier Global Description which have rank 1 for all the divisions with their premium values.

I have attached the sheet for reference.

Appreciate you help on this.

Thanks,
Rameez S

 

[Rameez Sarang]

Please could anyone suggest some solution

 

[vletm]

Rameez Sarang​

... then Your expected correct results are then what?
If You'll enter rank 5 ... then what should be expected correct results?
You wrote something about Division... that term can find in cell B14.
... but only some of those used Divisions below it can find.

 

[Rameez Sarang]

Rameez Sarang​

... then Your expected correct results are then what?
If You'll enter rank 5 ... then what should be expected correct results?
You wrote something about Division... that term can find in cell B14.
... but only some of those used Divisions below it can find.

Suppose I enter Rank 5, I should get the attached result. Whenver I change the rank, the fields in the screenshot

Carrier Global Description

Jul '20 - Jun '21 (Gross Premium)

Jul '21 - Jun '23 (Gross Premium)

will give me the details for that particular rank.

Division is just a heading in the table. It contains (FACULTATIVE, Finacial Solutions, Finex etc) which can be found in the 1st row.

 

[vletm]

Rameez Sarang​

questions:
#1 ... missed?
#2 ... based what? Where can find eg Finex -divisions values?
Division is just a heading in the table.
.. there are not just same texts with all those divisions somewhere ... 1st row.
eg Finex ... is different than FINEX GB.

 

[Rameez Sarang]

Rameez Sarang​

questions:
#1 ... missed?
#2 ... based what? Where can find eg Finex -divisions values?
Division is just a heading in the table.
.. there are not just same texts with all those divisions somewhere ... 1st row.
eg Finex ... is different than FINEX GB.

I have mentioned it in screenshot and corrected the file(attached)and removed the name GB from the headings.

Please check the cell no in the table of the attachment

 

[vletm]

Rameez Sarang​

Your data has still some challenges
... but something like this sample.

 

[Rameez Sarang]

Thank you very much. This is exactly what I needed. Its working as expected.

Please could you also help me with the formula in case I need the values for the attached table. Its the same only the tables are changed

refer screenshot & attachment

 

[vletm]

Rameez Sarang​

As You've read from Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

• Start a new post every time you ask a question, even if the theme is similar. The original author may continue asking questions whilst the post is in progress and of course if you are answering questions you may need to ask questions of the initial poster.

 

[Rameez Sarang]

Created a new post similar to the above.

Formula to Auto populate the fields in the table

Hi, I am working on the attached sheet and looking for a formula or solution which would auto populate the values in the table once I select the Carrier Global description. I have attached the sheet for reference. Appreciate you help on this.

chandoo.org

Please can you help on this