I am seeking advice on how to link two spreadsheets on a sharepoint site. What I would like to do is have a cell in one spreadsheet reference two other cells in the same spreadsheet and then cross reference those with the same two data cells in another spreadsheet and if the data matches from the two spreadsheets then pull data that is in a specified cell on the second spreadsheet into the initial cell on spreadsheet number 1.
Ex. Spreadsheet 1 cell A2(Formula cell) look at cells B2 and C2.
Cross reference cells B2 and C2 to spreadsheet 2 cells A2 and C2 and if B2 (spreadsheet 1) matches cell C2 (spreadsheet 2) and C2 (both spreadsheets) matches then pull whatever is in cell F2 (spreadsheet 2) over to cell A2 (Spreadsheet 1).
I hope this makes sense and is possible, thanks in advance!
Ex. Spreadsheet 1 cell A2(Formula cell) look at cells B2 and C2.
Cross reference cells B2 and C2 to spreadsheet 2 cells A2 and C2 and if B2 (spreadsheet 1) matches cell C2 (spreadsheet 2) and C2 (both spreadsheets) matches then pull whatever is in cell F2 (spreadsheet 2) over to cell A2 (Spreadsheet 1).
I hope this makes sense and is possible, thanks in advance!
