Reputation: 303

How to find a value instead of using IF function

I have a static table that includes the amount of money and the assigned letter for each amount.

The user should write the amount of money he has and the output should be according.

I have added the example below - I can use IF function if a value =< ; but it will be a big function

Upvotes: 1

Answers (3)

Reputation: 574

use Index,Match:

=INDEX(B2:B6,MATCH(C2,A2:A6,0))

or use this for other sheet:

=INDEX(Sheet1!B2:B6,MATCH(C2,Sheet1!A2:A6,0))

Upvotes: 0

Reputation: 75870

Here is a Microsoft365 option:

Formula in E2:

=@FILTER(B2:B6,A2:A6>=D2,"")

Upvotes: 2

Reputation: 152515

You can use Index/Aggregate:

=INDEX(B:B,AGGREGATE(15,7,ROW($B$2:$B$6)/($A$2:$A$6>=E2),1))

Upvotes: 2