Hi,
right now i am using a formula:
=IF(ISNUMBER(MATCH(A5,week1.xls!$A$1:$A$10,0)),IF(VLOOKUP(A5,week1.xls!$A$1:$D$10,3,0)>VLOOKUP(A5,week1.xls!$A$1:$D$10,4,0),1,0),)
that looks up the values in an external spreadsheet called "week1.xls". I have 19 of these, all named week1.xls, week2,xls, etc all the way up to week19.xls. I want to know how to make excel go through all these sheets retrieving the data. Thanx.
right now i am using a formula:
=IF(ISNUMBER(MATCH(A5,week1.xls!$A$1:$A$10,0)),IF(VLOOKUP(A5,week1.xls!$A$1:$D$10,3,0)>VLOOKUP(A5,week1.xls!$A$1:$D$10,4,0),1,0),)
that looks up the values in an external spreadsheet called "week1.xls". I have 19 of these, all named week1.xls, week2,xls, etc all the way up to week19.xls. I want to know how to make excel go through all these sheets retrieving the data. Thanx.