Indirect function help?

[helpme20]

can someone answer this.

This formula works


=ROUND(IFERROR(LOOKUP(1E+100,SEARCH(" "&prod&","," "&list01&","),'2012 price changes'!$J$3:$J$2521),""),4)

I have a cell, F11 that I have "J" in.

I want the formula to go to F11 and replace J with what is in F11

I can't get the below to work.

Can someone tell me where the indirect part of the formula goes. the below formula returns "You've entered too many arguments"


=indirect(ROUND(IFERROR(LOOKUP(1E+100,SEARCH(" "&prod&","," "&list01&","),concat("'2012 price changes'!$",f11,"$3:$",f11,"$2521)",""),4))


Prod is a single cell named range and list01 is a named range


Can someone help with this one?

 

[Fluff]

Maybe
=ROUND(IFERROR(LOOKUP(1E+100,SEARCH(" "&prod&","," "&list01&","),INDIRECT("'2012 price changes'!$"&F11&"$3:$"&F11&"$2521")),""),4)