need help with both which function & formula i need for the following

I have attached snippets of both the 'Excel Data' sheet & the 'Front Facing' sheet.
The intention is, on the front facing sheet, you need to select the
QOS --> ZONE --> BANDWIDTH
which in turn will populate the month cost in the 'Monthly Amount' column that matches the excell data

Hope this make sense & really appreciate your help

Cane

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

file is attached now
The intention is, on the front facing sheet, you need to select the
QOS --> ZONE --> BANDWIDTH
which in turn will populate the month cost in the 'Monthly Amount' column that matches the excell data

Hope this make sense & really appreciate your help

attached now sorry - new at this

I unmerged the merged cells.

Don't work with merged cells, you get in trouble with it sooner or later.



Tooldata

K60=LEFT(I61,1)&J61 and drag down.



Sheet ConnectivityBuilder

D4=LEFT(A4,1)&C4

E4=INDEX('Tool Data'!$K$60:$N$72,MATCH($D4,'Tool Data'!$K$60:$K$72,0),MATCH($B4,'Tool Data'!$K$60:$N$60,0))


See the attached file.

Thank you so much. I'm new at this & really appreciate your assistance.

Thankyou very much for your assistance

Glad to have helped.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

Thanks for the rep.

Glad I could help.

If you are satisfied with the solution, please mark the question solved.

@ccoseski You're Welcome. Glad to help . Thank You for the feedback and rep.

If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".