=HLOOKUP('Input'!$C$15,C2:L49,47,FALSE)
I would like a simple explanation of the above formula and how it plays in a workbook I was recently provided with?
I know the first part is taking the number in c15 of the Input sheet but its whats happening from there that confuses me. What's...