letters for numbers

G

Guest

all i am trying to reference worksheets using the INDIRECT function.
e.g. Sheet1, Sheet2, Sheet3
i am using formula = indirect("sheet"&a1&"BJ102") to refer to one of the
sheets. A1 will have either 1, 2, or 3 representing the sheet.
I want to copy this formula accross the row but i really want BJ to change
with every cell i.e. the next formula on the right should really read =
indirect("sheet"&a1&"BK102") without physically changing BJ to BK.

What is the best way to do this?

thanks much.

RK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

alter code to apply to range (links cells w/ row insertions) 1
Indirect formula not working if I give custom name for Sheets 1
make formula look at diff sheet 5
Code to format cells on several worksheets 2
EXCEL - IF(IFERROR(VLOOKUP question 0
Index formula with IF condition 1
Hyperlink via indirect cell reference 8
Indirect worksheet function 3

Top