Hi all,
I hope you can help as I appear to be missing something.
I have a value in CALC!C8 which I am trying to look up. =VLOOKUP(CALC!C8,VALIDATION!A6:C10,3,0)
So in the VALIDATION SHEET
A6 =0% B6 =50% C6 =1
A7 =50.01% B7 =60% C7 =2
A8 =60.01% B8 =65% C8 =3
A9 =65.01% B9 =70% C9 =4
A10...