Calculation based on a criteria

Originally Posted by Domski

Maybe like in the attached.

Built this in 2003 but in 2007 you can use this as the formula in C10:

=IFERROR(VLOOKUP(A10,$A$2:$B$4,2,FALSE),VLOOKUP(B10,$D$2:$E$5,2,TRUE))

Dom

Domski-

Thanks. This worked perfectly.

Quick responses. I will be back.