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

Usually when a post goes unanswered arounf here it means that either you
have asked a question without an answer or you have not explained your
requirements fully enough. Speaking personally I do not understand what it
is you are trying to do. Try re-stating the question as fully as you can
remembering that we cannot see your spreadsheet.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"GT" wrote in message
...
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.

It's 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