windsurfit
Board Regular
- Joined
- Mar 27, 2003
- Messages
- 228
=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 happening with C2:L49? and the 47, False part there is lots of data here....
Tough to remark accurately I'm sure so just a basis of understanding would be fine.
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 happening with C2:L49? and the 47, False part there is lots of data here....
Tough to remark accurately I'm sure so just a basis of understanding would be fine.