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!
Bookmarks