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.
Hi @Sergei, maybe you can assist me with my formula. I have 2 sheets and this is my syntax:look up data in sheet 1 column A Sheet 2; relating to data in column B of sheet 1; same data in sheet 1 column c with the value in column J in sheet 2