View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
l szym l szym is offline
external usenet poster
 
Posts: 3
Default help on data lookup

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