surely there is an easier way....

[aceee]

hey all.
i have a table
basicly looks like this..
1|.....A.....|.....b.....|.....c.....|
2|0..........|10.........|25%.....|
3|11........|20.........|35%.....|
4|21.........|30.........|45%.....|
5|31.........|40.........|55%.....|

Lets say in E1 i have "16" is there an easy way to make it return "35%"
instead of a huge amount of nexted IF statements, is there an easier way to lookup this table?

cheers

 

[Aladin Akyurek]

hey all.
i have a table
basicly looks like this..
1|.....A.....|.....b.....|.....c.....|
2|0..........|10.........|25%.....|
3|11........|20.........|35%.....|
4|21.........|30.........|45%.....|
5|31.........|40.........|55%.....|

Lets say in E1 i have "16" is there an easy way to make it return "35%"
instead of a huge amount of nexted IF statements, is there an easier way to lookup this table?

cheers

Try...

=LOOKUP(E1,$A$2:$A$4,$C$2:$C$4)

=VLOOKUP(E1,$A$2:$C$4,3,1)

=INDEX($C$2:$C$4,MATCH(E1,$A$2:$A$4,1))

They are all equivalent.

 

[aceee]

didn't think it could be that easy!

thaks

 

[Aladin Akyurek]

didn't think it could be that easy!

thaks

You are welcome. Thanks for providing feedback.