Trying to use drop list to find value

[=HPSF=RMP]

I have a validation drop down list with 4 items on it.
My index is located on cell P18.
I want to transfer the data to I15 from Sheet2!$B10, Sheet2!$B16,Sheet2!$B21 & Sheet2!$B26 based on the index number which is 1-4 respectively.

I hope I explained this correctly?

Thanks for any help.

 

[jindon]

Hi
try
in cell I15

=INDIRECT("Sheet2!B"&CHOOSE(P18,10,16,21,26))

 

[=HPSF=RMP]

Perfect!
Thanks so much!

 

[Aladin Akyurek]

Hi
try
in cell I15

=INDIRECT("Sheet2!B"&CHOOSE(P18,10,16,21,26))

There is no need for the volatile INDIRECT, which moreover locks the formula to the column B on Sheet2. Try:

=CHOOSE(P18, Sheet2!B10, Sheet2!B16, Sheet2!B21, Sheet2!B26)