G
GT
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
=INDEX($A$69:$I$76, MATCH(B81,$A$69:$A$76,), MATCH(B80,$A$69:$I$69,))
Please help!!
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!!