Excell linked table - reference cell information?

[Bill]

I have an excell sheet as a linked table in access 2003.
The table has 8 columns F1 thru F8
238 rows.
F1 thru F4 format as text - these are the parts description
F5 thru F8 as numbers - these are the sell price

I have a form which has combo boxes to make a choice.
The choice is a reference to a particular price and a cell location.
The price is on the linked sheet.
The form only uses one linked table.

how can I reference a particular cell which has the cost I require.
Once I have this cost or a series of them I wish to sum them.

Its a cost sheet.
A particular item has 4 different sizes (columns F5 thru F8)
The rows are options or price adders.

So if I select item 2 which uses Column F7, the options are say rows 101,
150, 175, 202. These 4 cells now get added together to give me a final price
which I can somehow show on the form.

Anyone done anything like this?
How do I reference the cells which are now a column row in the linked table.
Need some ideas - cause i'm lacking at the moment.

Its the new year - nothing like curve ball.

Thanking all in advance.
Best regards

 

[Douglas J. Steele]

Ignore the fact that your data's coming from Excel: it's irrelevant. As far
as Access is concerned, you have a table of price information, and you treat
it the same as you would any other table: you write queries to retrieve the
specific data you want, or you use DLookup.

That having been said, you might consider massaging the data once you get it
into Access so that it's normalized. Depending on the requirements, it's
possible that a UNION query on the linked table might be all you need to
produce a normalized view.