I want to enter a number in cell A1 (Sheet 1) and have a formula which gets excel to go to sheet 2 column A finds the two numbers the entered value falls between then returns the number adjacent in column B (sheet 2) to cell A2 (Sheet 1).
E.g. I enter 847 into cell A1 (Sheet 1). Therefore a value of 14 appears in A2 (Sheet 1)