Forum Discussion
Can't close the formula
How do I close this formula? It involves checking data and searching for it on multiple sheets. My colleague gave me this info: For the Lookups from the form to the year data, I would recommend i...
=IF(A4='8P'!A4,VLOOKUP(A4,CLASS8P,4,FALSE),IF(A4='8O'!A4,VLOOKUP(A4,CLASS8O,4,FALSE),IF(A4='8S'!A4,VLOOKUP(A4,CLASS8S,4,FALSE),IF(A4='8H'!A4,VLOOKUP(A4,CLASS8H,4,FALSE),IF(A4='8t'!A4,VLOOKUP(A4,CLASS8T,4,FALSE),"ERROR")))))
This formula works in my sheet.