Return Value in Column 2 Q

[John]

I have a table which contains 2 columns and 30 rows of Data

Col1 = Sales
Col2 = ManHours

I wish to "lookup" a value that is input into A1 (which will be a sales
value) and Return the appropriate ManHours associated with these sales. My
only problem is that my value in A1 will probably not match exactly what is
in Col1.

For example Col1 increments in 100's, so it will show sales of 9,000, 9,100,
9,200 etc
Opposite these Sales values will be Manhours, say, 50, 55, 58 etc
Cell A1 might contain 9,040, thus the value I want returned is 55. Likewise
if A1 = 9,025 this should also = 55

How would I do this? Its a lookup Q but between ranges

Thanks

 

[John]

Just found a post from J.E. McGimpsey, using suggested

=INDEX(TableofHours,
MATCH(A1,OFFSET(TableofHours,,,,1),TRUE),MATCH(C3,OFFSET(TableofHours,,,1),FALSE))

Don't know what its doing but it comes up with the correct answer!

Thanks