Can you tell me what this formual does? Need to know why it's pulling the result it is. (Previous user's spreadsheet.)
=IF(ISERROR(F2),0,LOOKUP(C2,INDIRECT(ADDRESS(F2,5,,,F$1)):INDIRECT(ADDRESS(F2,15,,,F$1)),INDIRECT(ADDRESS(F2+1,5,,,F$1)):INDIRECT(ADDRESS(F2+1,15,,,F$1))))
Thank you.
=IF(ISERROR(F2),0,LOOKUP(C2,INDIRECT(ADDRESS(F2,5,,,F$1)):INDIRECT(ADDRESS(F2,15,,,F$1)),INDIRECT(ADDRESS(F2+1,5,,,F$1)):INDIRECT(ADDRESS(F2+1,15,,,F$1))))
Thank you.