Selecting Columns and rows via variable input

Not sure where to post this so here goes for some help.

I am using Excel for MAC 2011.

I have a spreadsheet for pricing calculation which has 22 columns and 32 rows.
I wish to drive this from another sheet to hide raw pricing from the customer.
I have 5 pricing elements that I will input based on the customer requirements.
The first data input will select the column to be used.
subsequent 4 data inputs will select the correct cell within that column.
The first that was input is only a reference, the balance will be summed.

I am ok with creating basic calculations and formulas etc, but no idea if this is even possible or where to start.

Anyone give me any pointers would be appreciated.

rgds
Alistair

Hi,
Thanks for the response. I have attached my worksheet layout.
The 1st data inputs will be the length and width of the frame.
These added together will give the length in row 3.

ie if the total is 1140 then this will select column K as its higher than J3, but lower than K3.
if the next input for the moulding code is 8 then the cell selected should be K12.
If glass is plain then cell K22
Mount std double then K31

I would like to drive this from a separate sheet,using pop up windows for input, the data input and cells selected would populate a spec sheet/invoice for discussion with the customer.

Been doing some uTubing and think VBA may be the way to go, but could do with some help. Long time since I did any programming and looks more complicated than my use of formulae.

Hoping for some great help and advise - even if you tell me that it cant be done.
My vision would be to drive this via excel on my iPad.

many thanks in advance.

rgds
Alistair

Not sure how to mark this solved but I have now worked out the coding in VBA, although I will not be able to use on my iPad, as I am advised it does not support.

rgds
Alistair