Vlookup possibly ?

[Steve]

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

 

[Pete_UK]

Put this in L11:

=IF(OR($C$6="",$C$6<0,$C$6>5),"",IF(INDEX(L$15:L$19,MATCH($C$6,$C$15:$C
$19,0))="","",INDEX(L$15:L$19,MATCH($C$6,$C$15:$C$19,0))))

Then you can copy it across to P11.

Hope this helps.

Pete

 

[Steve]

Perfect. I hadn't given you all the ranges ( I actually had data through row
25, and C6 could've gone up to 13, so when I adjusted your formula as below
in D11 and dragged it to P11, it all worked EXACTLY how I was hoping.

=IF(OR($C$6="",$C$6<0,$C$6>13),"",IF(INDEX(D$13$25,MATCH($C$6,$C$13:$C$25,0))="","",INDEX(D$13$25,MATCH($C$6,$C$13:$C$25,0))))


Thanks again,

Steve

 

[Pete_UK]

You're welcome, Steve - glad it worked for you.

Pete