I have this data in rows C, & L thru P. In C6, if I manually enter a 3,
I need the data in row 17 to populate row 11 as shown (L11="",
M11="",N11=-972, O11=-975 and P11=-974. And if I manually enter a 5 in C6, I
need the data in row 19 to populate row 11 as shown (L19 = -589, M19= -582,
N19 = -582, O19= - 585, & P19 = -584. In other words, I want formulas in row
11 to lookup whats in C3, and find that number in C15:C19, and then populate
the numbers to the right in the appropriate row( either 15, 16, 17, 18 or
19), and have them in row 11.

I hope this makes sense.

Thank you,

Steve

C L M N O P

In C6 -3

Row 11 -972 -975 -974

C15 =1 -2921
C16 =2 -1461 -1460
C17=3 -972 -975 -974
C18=4 -729 -729 -732 -731
C19=5 -589 -582 -582 -585 -584