I am trying to extract number (%) from a table using €œlookup€� however the
first column to be used is made up of a range versus merely sequential
numbers e.g. 0 =70, 70<=80, 80<=90 and so on and then the row used is
similar e.g. 0 = 300000, 300000 <=400000, 400000 <=500000 etc.

Its not recognising or been able to for example 77 which is obviously in
70<=80

=INDEX($A$69:$I$76, MATCH(B81,$A$69:$A$76,), MATCH(B80,$A$69:$I$69,))

Please help!!

--
Just an amateur Microsoft Office enthusiast