Access Lookup In Excel

[Bizylizard]

I apologize if I posted this in the wrong section

I have a Matrix in Excel example below that includes a top row % labeled M and a first Column % labeled P. What I am trying to do is from Access go to this Excel Matrix and import a specific value or sets of values. For example if M% is 106% and P% is 195% then the result should be 215%. Also another dilemma is if the value I have for P in Access is 194% how do I direct it to the result for 195%. Is their a way that Access and Excel communicates in this way or is there a way for me to put the same data set from Excel into Access but then how will I do an Access Lookup achieving the same end. Thanks

M % 110% 106% 102%
P %
200% 222% 216% 212%
195% 221% 215% 211%
190% 219% 213% 209%
185% 217% 211% 207%
180% 216% 210% 206%
175% 214% 208% 204%

 

[lespaul]

A lookup table like this will be able to pull the same results as your matrix:
[tt]
MValue PValue Result
110 200 222
110 195 221
110 190 219
110 185 217
110 180 216
110 175 214
106 200 216
106 195 215[/tt]

As far as your query goes, I'll have to think about that and get back to you.


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins