Code: Select all
=IFERROR(IF(ISNA(CONCATENATE(VLOOKUP(Table_AllTask[[#This Row],[ID]],SysTest[[#All],[ID]:[Rank]],10,FALSE),VLOOKUP(Table_AllTask[[#This Row],[ID]],FSTB[[#All],[ID]:[Rank]],10,FALSE),VLOOKUP(Table_AllTask[[#This Row],[ID]],SIM[[#All],[ID]:[Rank]],10,FALSE))),IF(ISNA(CONCATENATE(VLOOKUP(Table_AllTask[[#This Row],[ID]],SysTest[[#All],[ID]:[Rank]],10,FALSE),VLOOKUP(Table_AllTask[[#This Row],[ID]],FSTB[[#All],[ID]:[Rank]],10,FALSE))),IF(ISNA(CONCATENATE(VLOOKUP(Table_AllTask[[#This Row],[ID]],SysTest[[#All],[ID]:[Rank]],10,FALSE),VLOOKUP(Table_AllTask[[#This Row],[ID]],SIM[[#All],[ID]:[Rank]],10,FALSE))),IF(ISNA(CONCATENATE(VLOOKUP(Table_AllTask[[#This Row],[ID]],FSTB[[#All],[ID]:[Rank]],10,FALSE),VLOOKUP(Table_AllTask[[#This Row],[ID]],SIM[[#All],[ID]:[Rank]],10,FALSE))),IF(ISNA(VLOOKUP(Table_AllTask[[#This Row],[ID]],SysTest[[#All],[ID]:[Rank]],10,FALSE)),IF(ISNA(VLOOKUP(Table_AllTask[[#This Row],[ID]],FSTB[[#All],[ID]:[Rank]],10,FALSE)),VLOOKUP(Table_AllTask[[#This Row],[ID]],SIM[[#All],[ID]:[Rank]],10,FALSE),VLOOKUP(Table_AllTask[[#This Row],[ID]],FSTB[[#All],[ID]:[Rank]],10,FALSE)),VLOOKUP(Table_AllTask[[#This Row],[ID]],SysTest[[#All],[ID]:[Rank]],10,FALSE)),CONCATENATE(VLOOKUP(Table_AllTask[[#This Row],[ID]],FSTB[[#All],[ID]:[Rank]],10,FALSE),VLOOKUP(Table_AllTask[[#This Row],[ID]],SIM[[#All],[ID]:[Rank]],10,FALSE))),CONCATENATE(VLOOKUP(Table_AllTask[[#This Row],[ID]],SysTest[[#All],[ID]:[Rank]],10,FALSE),VLOOKUP(Table_AllTask[[#This Row],[ID]],SIM[[#All],[ID]:[Rank]],10,FALSE))),CONCATENATE(VLOOKUP(Table_AllTask[[#This Row],[ID]],SysTest[[#All],[ID]:[Rank]],10,FALSE),VLOOKUP(Table_AllTask[[#This Row],[ID]],FSTB[[#All],[ID]:[Rank]],10,FALSE))),CONCATENATE(VLOOKUP(Table_AllTask[[#This Row],[ID]],SysTest[[#All],[ID]:[Rank]],10,FALSE),VLOOKUP(Table_AllTask[[#This Row],[ID]],FSTB[[#All],[ID]:[Rank]],10,FALSE),VLOOKUP(Table_AllTask[[#This Row],[ID]],SIM[[#All],[ID]:[Rank]],10,FALSE))),"")
Yours is soooo way cooler and less bighugeuglyOMGbeastmonster! Thanks sooo much... again! YOU ROCK! Am I supposed to do something to show this is solved? Other boards require that, it improves your stats of awesomeness or something...