Lookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GT - 24 Aug 2007 10:30 GMT

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

Signature

Just an amateur Microsoft Office enthusiast

Reply to this Message

Sandy Mann - 24 Aug 2007 22:21 GMT

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.

Signature

HTH

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

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

>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
[quoted text clipped - 7 lines]
>
> Please help!!

Reply to this Message