Convert if statement to Case Function

[KarlSm]

I'm trying to get the following code to work as a Case Function and can't seem to find how i would define the different ranges to test.

My working VBA IF statement, which populates the column M cells with 410, 470, 430, and 420 depending on what is found in column L, I or A, is:

Please Login or Register  to view this content.

Can anyone help me convert that into a Case Function?

[JBeaucaire]

The Select Case method is not appropriate for your scenario. A VBA version of your IF tests, since each one is different, would be:

Please Login or Register  to view this content.

However, I hate looping row by row when your formula method could actually do it all in one fell swoop, I would change it to this:

Please Login or Register  to view this content.

This will put in the formulas, then remove them, leaving the values behind.

[KarlSm]

Thanks for your help