Shorter version:

=LOOKUP(E4,{0.05,0.14,0.23},K7:M7)


"Teethless mama" wrote:

=INDIRECT(LOOKUP(E4,{0.05,0.14,0.23},{"K7","L7","M 7"}))


"DJ" wrote:

Ok im really new to this and have been reading for hours. Heres what I'm
trying to do.

If E4=either.05, .14, .23 then B19=K7IF.05, L7IF.14, M7IF.23

hope that makes sense to someone thanks for any help given