Code:
=IF($G$2="Premier",VLOOKUP($C6,Premier!$P$33:$AO$56,4,FALSE),IF($G$2="Championship",VLOOKUP($C6,'Championship'!$P$33:$AO$56,4,FALSE),
IF($G$2="England1",VLOOKUP($C6,England1!$P$33:$AO$56,4,FALSE),IF($G$2="England2",VLOOKUP($C6,England2!$P$33:$AO$56,4,FALSE),
IF($G$2="Conference",VLOOKUP($C6,'Conference'!$P$33:$AO$56,4,FALSE),IF($G$2="France1",VLOOKUP($C6,France1!$P$33:$AO$56,4,FALSE),
IF($G$2="France2",VLOOKUP($C6,France2!$P$33:$AO$56,4,FALSE),IF($G$2="Nemacka1",VLOOKUP($C6,Nemacka1!$P$33:$AO$56,4,FALSE),
IF($G$2="Nemacka2",VLOOKUP($C6,Nemacka2!$P$33:$AO$56,4,FALSE),IF($G$2="Italija1",VLOOKUP($C6,Italija1!$P$33:$AO$56,4,FALSE),
IF($G$2="Italija2",VLOOKUP($C6,Italija2!$P$33:$AO$56,4,FALSE),IF($G$2="Spanija1",VLOOKUP($C6,Spanija1!$P$33:$AO$56,4,FALSE),
IF($G$2="Spanija2",VLOOKUP($C6,Spanija2!$P$33:$AO$56,4,FALSE),"nij")))))))))))))
=IF($G$2="Premier",VLOOKUP($C6,Premier!$P$33:$AO$56,4,FALSE),IF($G$2="Championship",VLOOKUP($C6,'Championship'!$P$33:$AO$56,4,FALSE),
IF($G$2="England1",VLOOKUP($C6,England1!$P$33:$AO$56,4,FALSE),IF($G$2="England2",VLOOKUP($C6,England2!$P$33:$AO$56,4,FALSE),
IF($G$2="Conference",VLOOKUP($C6,'Conference'!$P$33:$AO$56,4,FALSE),IF($G$2="France1",VLOOKUP($C6,France1!$P$33:$AO$56,4,FALSE),
IF($G$2="France2",VLOOKUP($C6,France2!$P$33:$AO$56,4,FALSE),IF($G$2="Nemacka1",VLOOKUP($C6,Nemacka1!$P$33:$AO$56,4,FALSE),
IF($G$2="Nemacka2",VLOOKUP($C6,Nemacka2!$P$33:$AO$56,4,FALSE),IF($G$2="Italija1",VLOOKUP($C6,Italija1!$P$33:$AO$56,4,FALSE),
IF($G$2="Italija2",VLOOKUP($C6,Italija2!$P$33:$AO$56,4,FALSE),IF($G$2="Spanija1",VLOOKUP($C6,Spanija1!$P$33:$AO$56,4,FALSE),
IF($G$2="Spanija2",VLOOKUP($C6,Spanija2!$P$33:$AO$56,4,FALSE),"nij")))))))))))))
Premier,Championship ,League1 itd ,su imena listova i u svim listovima se podaci koji mi trebaju nalaze u P33:AO56 ...
u G2 se nalazi padajuca lista sa imenima listova .... Ovo ovako funkcionise,ali sad zelim da dodam jos nekih 10-15 liga (radnih listova) . Da li moze da se uprosti formula ,da ne moram da ubacujem jos 10-15 IF-ova za te nove lige?