Table that includes a comparison

If I understand this, you have 3 price plans for calls in 4 different areas and there are different options dependent upon the local.

This is how I understand your description.

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Personally, I think that you might be further ahead by selecting all the data (once you have the complete table) then use on the Data tab the FILTER. That way you can pull all rows that apply to a plan, or region etc.

If I understand this, a drop down list is possible but I have reservations about using one for this as you would be seeing a very limited set of your data. Having a one table would allow you to either use a filter to get the records you want or you can see the overall picture at a glance.

I forgot to ask how the worksheet is to be used. The use for which it is intended will have a bearing on how the data should be laid out. You don't want it so complicated that it is not readily understood. Nor do you want it so simple that all the pertinent data isn't readily seen.

I am not a designer of presentation material. I did however learn that if you present too much information at a time, it is lost on the target audience.

I assume that this will be a standard presentation type where you will be explaining different points while showing your visual material. The visual material should only be there to give a visual picture of what you are saying. If the visual material is too complicated, the audience will be trying to figure out the visuals and probably not even hear you.

You have your data broken down into 3 parts. I would present each part separately.

You evidently are wanting to make a comparison with your competitor. You show what the competitor calls their plan but not how they compare.

As I said before, I am not a presentation designer but here are a few ideas for you to play around with. I prefer the second idea but, that is just me. You may or may not want to use colour. If you use colour, use what you consider a favourable colour for your company and a toned down one for the competitor. You might want to use a font format to show where you have the competition beat and another to show where they might have an advantage.

Good luck.