Okay, so I'm having trouble explaining this, let alone doing it.
I want a cell returning a different value from another excel file, depending on what is typed in cell 'x'.
So, if I type "3" in cell B2 a certain value should be entered in cell B10, from another excel file.
If I type "10" in cell B2, another calue should be entered in B10, from the same file as above.
Is that possible, and if so, how?
Hope you can help me out!
Yes, it's possible.
How depends on what these numbers refer to and how they relate to the other file.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Okay, so I want 'Sr.' to take data from 'Sr1'
If B2 in 'Sr.' is 11, the data in B10 should return data fom cell A11 in 'Sr1'.
If B2 is 12, data in B10 should return data from cell A12 from 'Sr1', and so forth..
With both workbooks open in memory you could use the INDIRECT function.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Richard, that wouldn't always be possible, since I want it to link to several files.
I work on a virtual desktop with a drive accessable by my entire organisation, so this would be some kind of masterfile collecting the numbers from several workbooks, depending on what I write in the "mastercell"
So when you open this file and you enter the week number in cell B2, you should get numbers from an array of workbooks.
Why do you think it's not possible?
Your original post mentioned looking at a cell in another workbook and hence a formula could contain the name of the other workbook and the master cell would provide the row number to be used in Indirect part of the formula.
You now appear to be saying that there are many workbooks. In that case yo'll need two master cells. One that contains the name of a workbook and one that contains the row number.
However it's not clear from your explanation whether there is a one to one relationship beween the summary workbok and another workbook or whether you need to sum the numbers from several workbooks in a one to many relationship.
I have quite possibly misunderstood you then.
And have not made my intentions with my workbook entirely clear either.. my lack of working with excel makes it difficult to explain with the correct terms.
I'll try to write it again, with a little more detail.
So, I want one "mastercell" where you can write a weeknumber. When writing the weeknumber, all cells containing the formula I'm looking for will return with a value from another workbook. So writing '11' will give me all data from week 11 in the other workbooks.
This will most likely require a lot of manual work, but that's fine.
Does that clear things up a little more?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks