Lookup

[Guest]

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!!

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk