(Solved) : 1 Use Vlookup Function Cell F25 Catastrophecoveragelowactivity Worksheet Determine Appropr Q35182705 . . . .

1 Use a VLOOKUP function in cell F25 of theCatastropheCoverageLowActivity worksheet to determine theappropriate Copayment for the first visit to a Primary Doctor. TheÒTypeÓ in cell D25 is one of the parameters. Use absolute andrelative references when appropriate 2 0.5 Reuse your formula incell F25 and paste it down to complete the “Copayment” column ofthe table. 3 1.25 In cell G25 of the CatastropheCoverageLowActivityworksheet calculate the ÒPayment towards DeductibleÓ as the lesser(use the MIN function) of the ÒClaim AmountÓ or the Deductible forthe indicated ÒTypeÓ. You will need to use a VLOOKUP function todetermine the deductible for the indicated ÒTypeÓ.