Jun 25 2019 12:04 PM
Hello,
I've fairly new to Excel so excuse me if I don't explain things correctly. I have an Excel file in a folder under My Documents on my computer (Windows 10). I have another Excel file where I want a cell to look up the contents of a cell in that other file and display it. I've been trying to figure out how to do this and I'm having trouble.
Can anyone give me a suggestion?
Thank you!
Jun 25 2019 01:14 PM
Solution
If you mean to link the cells, open both files, in the target cell of one file start typing = when click on source cell in another file. After that you may close this file.
Jun 27 2019 06:15 AM
@Sergei Baklan Wow! That was so easy and here I am wracking my brain thinking it is this complex formula!
Thank you so much! :)
Jun 27 2019 06:26 AM
Jun 25 2019 01:14 PM
Solution
If you mean to link the cells, open both files, in the target cell of one file start typing = when click on source cell in another file. After that you may close this file.