Small Cell Display Question

[Bsir]

Hi, I've spent some time researching an answer to my problem but to little avail. I believe it is a relatively simple problem but I don't know much more than the basics on using excel, so I've come to this board for some help.

In any case, I have a single excel file with two data sheets in said file. I wish to use the second sheet to view text entries from cell in first sheet (which has around 75 unique sets of data with each with 40 different entries). On the second sheet I want to be able to enter the set of data I wish to view (1-75) and have the corresponding entries (1-40) fill themselves from that data set.

I thought I could have a cell in the second sheet for the data set number, and then use that cell to direct the other cells to display the correct data entry. I thought a formula such as this one would work for cell A2 of Data Sheet 2: ='Data Sheet 1'!A(2+('Data Sheet 2'!A1*40)) but now I realize that you cannot enter parenthesis within a cell name without destroying the function (I get a #NAME error).

So my question is, how does one display the text in a cell on another sheet based on the value in a cell on the same sheet?

[ConneXionLost]

It depends on how your data is set up on the first sheet, but usually it is with the VLOOKUP function.

Cheers,

[batman07]

Hi Bsir,

Try indirect reference function, or copy/paste this formula to see if it will work:

Please Login or Register  to view this content.

Regards,
Batman

[Bsir]

It depends on how your data is set up on the first sheet, but usually it is with the VLOOKUP function.

Cheers,

I think this may have worked if it weren't for my numbering column repeating itself, and not being individually unique (while the entries for each are) Thank you for the suggestion!

Hi Bsir,

Try indirect reference function, or copy/paste this formula to see if it will work:

Please Login or Register  to view this content.

Regards,
Batman

Batman to the rescue! This worked out perfectly and I'm able to make it work for the rest of my cells as well. Thank you kind sir for helping out a simpleton such as myself!