Use cell values as way to reference to cells on another sheet - easy as INDIRECT?

[Adam.V]

Hi,

I am not that used to working with the INDIRECT command, which i suspect might be the key here, so this might be easy solved.

excel.jpg

I have a column ”Nr” (A) that contains the names, or if you will the indexes, that has a corresponding sheet with the same name (i.e. there is sheet called ”10.0.1” with information in cell B8 i want to display on my main index page on the row that has 10.0.1 in the ”Nr” column). I want to use this number/index that is in column ”Nr” for each of the rows to reference for all the other columns to pull the information that is on the sheets to the main index page that is featured on the image above.

I can't get it to work with the INDIRECT command as it seems to have a hard time understanding that the numbers it’s pulling from the A column should be treated as a reference to an other sheet in the same workbook.

I have over 400 rows * 8 columns for each rows so all the help i can get to speed up this process is super valuable (don’t want to spend Christmas writing them all by hand, or do some kind of macro that is well above my level of knowhow) - thanks in advance!

[protonLeah]

deleted 12/21

[Pete_UK]

Try it like this:

=IF(INDIRECT("'"&A404&"'!B8")="";"";INDIRECT("'"&A404&"'!B8"))

You need to include the apostrophes around the sheet name. Also, you should check that you don't have any leading or trailing spaces in A404 or in the sheet name itself.

Hope this helps.

Pete

[Adam.V]

It seems like it’s working!

Thanks a lot Pete_UK! I’m eternally grateful for the quick and helpful response!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.