How to Create a Lookup on Two Variables

[lardog]

I am trying to create a query that will return a value based on two variables. I want to know what the intersecting value is for my variables. Using the table below, if beneficiary is 60 and participant is 30 then the value to return is 31, likewise if beneficiary is 70 and participant is 10 then the return value is 58. Any assistance you can provide is greatly appreciated.

Beneficiary Age
Participant 50 60 70
10 30 45 58
20 25 35 46
30 28 31 39
40 34 33 36
50 42 37 36
60 51 44 40

 

[Yogi Anand]

Hi lardog:

If I have understood you correctly, you should find the following of some interest ...

y030905h1.xls
	A	B	C	D	E	F	G
1		Age2				Age1	30
2	Age1	50	60	70		Age2	60
3	10	30	45	58
4	20	25	35	46		Answer	31
5	30	28	31	39
6	40	34	33	36
7	50	42	37	36
8	60	51	44	40
Sheet9

Does it help? If I have misunderstood your question -- my apologies!