Hello all,
I need to replace the following part of a formula:
INDIRECT("'"&$C$1&"'!$A$1:$t$32"),3,FALSE
With this:
INDIRECT("'"&$C$1&"'!$A$1:$t$32"),5,FALSE
This is part of a larger formula:
=IF((VLOOKUP(B5,INDIRECT("'"&$C$1&"'!$A$1:$t$32"),3,FALSE))=0,"",VLOOKUP(B5,INDIRECT("'"&$C$1&"'!$A$1:$t$32"),3,FALSE))
where B5 changes based on the row/column.
  • Actually I only really need to change the vlookup from column 3 to column 5.
  • Alongside this I also need to change the text "KS2Av" to "KS3Av"
  • I need this to happen in range A:AJ, rows 8,16,27,35 all in sheet "Seating Plan" (ranges: A8:AJ8, A16:AJ16, A27:AJ27, A35:AJ35)

I then need vba to do the reverse, so that I can set the button up to show KS2Av on one click, show KS3Av on other click. I can't upload the file as it contains confidential data.

Your help is greatly appreciated! Luke