THANKS, you just saved me a ton of time. this worked great!!
--
szy


"Pete_UK" wrote:

Suppose you use D1 for the column heading (medicare) and E1 for the
value of cpt (70418). Put this formula in F1:

=INDEX($B$2:$C$4,MATCH(E1,$A$2:$A$4,0),MATCH(D1,$B $1:$C$1,0))

Adjust your ranges to suit your real table. Change the values in D1
and E1 for other returns.

Hope this helps.

Pete

On Jan 28, 6:38 pm, l szym wrote:
cpt medicare aetna
70417 143.00 145.00
70418 200.00 250.00
70419 300.00 350.00

I need a formula that will give the result of 200.00 by defining cpt =70418
for medicare or 70419 & aetna gives me 350.00 as the result
--
szy