Use a formula to designate a cell in another worksheet

ortnpalms 

It appears that you are trying to use a combination of text and cell references in your formula to reference a cell in another worksheet. You are on the right track, but the formula needs a slight adjustment. In Excel, you can use the INDIRECT function to create a cell reference based on text.

The INDIRECT function is available in Excel for both Windows and Mac, and it works similarly in both versions.

Here is the correct formula to reference a cell in the "Items" worksheet using the value in cell C5 of the "Subjects" worksheet:

=INDIRECT("Items!A" & C5)

Here is how it works:

• "Items!A" specifies the sheet name ("Items") and the column letter ("A").
• & is used to concatenate (join) the sheet name and column letter with the value in cell C5.

• C5 contains the row number you want to reference.

So, if cell C5 in the "Subjects" worksheet contains the value "2," this formula will create a reference to cell A2 in the "Items" worksheet.

Make sure to enter this formula in cell A10 of the "Subjects" worksheet. It should display the value from the corresponding cell in column A of the "Items" worksheet. The text was created with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark them as helpful and like it!

This will help all forum participants.