help on data lookup
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
|