software

I have an excel spreadsheet for employee health insurance deductions. In the
coverage colum I have coverage noted as either E, ES, EC, F or D. What I'm
looking for is a function that will allow me to display weekly deductions in
an adjacent cell. Ex: E=$26.55 Is this possible?

=LOOKUP(A1,{quot;dquot;,quot;equot;,quot;ecquot;,quot;esquot;,quot;fquot;},{1,26.55,3,4,5} )

Vaya con Dios,
Chuck, CABGx3
quot;rgydiceyquot; wrote:

gt; I have an excel spreadsheet for employee health insurance deductions. In the
gt; coverage colum I have coverage noted as either E, ES, EC, F or D. What I'm
gt; looking for is a function that will allow me to display weekly deductions in
gt; an adjacent cell. Ex: E=$26.55 Is this possible?

Let's assume the coverage code is in column D and you want the numbers in
column E, starting in row 2

change the 26 through 66 as appropriate

=LOOKUP(E2,{quot;Dquot;,quot;Equot;,quot;ECquot;,quot;ESquot;,quot;Fquot;},{26,36,46,56,66 })

quot;rgydiceyquot; wrote:

gt; I have an excel spreadsheet for employee health insurance deductions. In the
gt; coverage colum I have coverage noted as either E, ES, EC, F or D. What I'm
gt; looking for is a function that will allow me to display weekly deductions in
gt; an adjacent cell. Ex: E=$26.55 Is this possible?

sorry about the typo

=LOOKUP(D2,{quot;Dquot;,quot;Equot;,quot;ECquot;,quot;ESquot;,quot;Fquot;},{26,36,46,56,66 })quot;Duke Careyquot; wrote:

gt; Let's assume the coverage code is in column D and you want the numbers in
gt; column E, starting in row 2
gt;
gt; change the 26 through 66 as appropriate
gt;
gt; =LOOKUP(E2,{quot;Dquot;,quot;Equot;,quot;ECquot;,quot;ESquot;,quot;Fquot;},{26,36,46,56,66 })
gt;
gt; quot;rgydiceyquot; wrote:
gt;
gt; gt; I have an excel spreadsheet for employee health insurance deductions. In the
gt; gt; coverage colum I have coverage noted as either E, ES, EC, F or D. What I'm
gt; gt; looking for is a function that will allow me to display weekly deductions in
gt; gt; an adjacent cell. Ex: E=$26.55 Is this possible?