vlookup...&row

[bluepenink]

Hello i have the following formula in place...the sum(vlookup works fine

however, i am trying to modify it so the vlookup can reference a string i.e. P1 etc as I move my formula across, so the "row(C6)" is giving me an error, can i get some suggestions? thx you!

=SUM(VLOOKUP($A10,'Bonus Template Actuals&" "&ROW(C6)!$A$10:$I$121,{2,3},0))

basically, its lookup a sheet called "Bonus Template Actuals P1"

thx you!

 

[jimrward]

you need to use the INDIRECT function I think i have guessed correct for below

=SUM(VLOOKUP($A10,INDIRECT("Bonus Template Actuals P"&ROW(C6)& "!$A$10:$I$121")
,{2,3},0))