Hi there,
Here is my problem: I have a master spreadsheet that contains a list of 250 student names.
That file has been split into eight smaller spreadsheets so that teachers can enter details about the students.
I would like to use a vlookup formula to update the entries on the master spreadsheet as the smaller ones are filled in.
If I tell the vlookup formula which spreadsheet to look at I can make it work. But is there a single formula I can use that will search through one file, then, if it doesn't find the name, search through the next file and so on.
In other words I need a vlookup formula that can search through eight different external spreadsheets looking for a single entry.
Here is an example of the Vlookup formula that works with just one spreadsheet:
=VLOOKUP(D:D,'[Y7 Annual Report_English_7A1.xls]Subject Report'!$C:$N,8,FALSE)
I would like it to go on to search through "Y7 Annual Report_English_7A1.xls" and so on.
Any help is very appreciated. I've been looking through google and the forums but can't seem to make anything work.
Here is my problem: I have a master spreadsheet that contains a list of 250 student names.
That file has been split into eight smaller spreadsheets so that teachers can enter details about the students.
I would like to use a vlookup formula to update the entries on the master spreadsheet as the smaller ones are filled in.
If I tell the vlookup formula which spreadsheet to look at I can make it work. But is there a single formula I can use that will search through one file, then, if it doesn't find the name, search through the next file and so on.
In other words I need a vlookup formula that can search through eight different external spreadsheets looking for a single entry.
Here is an example of the Vlookup formula that works with just one spreadsheet:
=VLOOKUP(D:D,'[Y7 Annual Report_English_7A1.xls]Subject Report'!$C:$N,8,FALSE)
I would like it to go on to search through "Y7 Annual Report_English_7A1.xls" and so on.
Any help is very appreciated. I've been looking through google and the forums but can't seem to make anything work.
