Lookup ranges of cells put into others worksheet into range of cells with data validation

There a note on file try to do lookup worksheet Call B
Cells

B2:B7,E2:E7,H2:H7,K2:K7,N2:N7,Q2:Q7,T2:T7

B10:B15,E10:E15,H10:H15,K10:K15,N10:N15,Q10:Q15T10:T15

B18:B23,E18:E23,H18:H23

goto worksheet Call P

put in Cells L8:13

when you change cell F1.

easiest way I can think of is this simple multiple if/then statement in L8 dragged down...
=IF($F$1=1,B!B2,IF($F$1=2,B!E2,IF($F$1=3,B!H2,IF($F$1=4,B!K2,IF($F$1=5,B!N2,IF($F$1=6,B!Q2,IF($F$1=7,B!T2,IF($F$1=8,B!B10,IF($F$1=9,B!E10,IF($F$1=10,B!H10,IF($F$1=11,B!K10,IF($F$1=12,B!N10,IF($F$1=13,B!Q10,IF($F$1=14,B!T10,IF($F$1=15,B!B18,IF($F$1=16,B!E18,IF($F$1=17,B!H18,"")))))))))))))))))

I guess that solved it for you, thank you for the rep!

I will check it later

it works, but there no data in cells in putting zero in worksheet call P cells L8:L18

Thanks You

Voyager22

there is no data because you didn't have data in your cells. In my test I had to populate them with data just to make sure that something came back from each area as a test.

if you are wanting them to be blank if nothing is in those cells then it will be a much longer formula. OR, you could use formatting to change the color of the font in the destination cells in L8 where if the cell value is 0 you could change the font color to the same color as the fill for the cell so it would effectively disappear.