IF formula multiple criteria

[Kbouz]

Hi, I need help with an IF formula to express the following :

As example there are 6 levels and each level correspond to a range in spreadsheet :
Column D Column E Column F
1 100 200
2 201 300
3 301 400
4 401 500
5 501 600
6 601 700

In column A I have :
A1 240
A2 350
A3 550
A5 667
And so on...

I need the IF formula to find in column B which the level I mentioned above .... after formula is applied :
A1 240 2
A2 350 3
A3 550 5
A5 667 6
It make be basic , but I really need help on this ,


thanks in advance

 

[63falcondude]

Re: IF formula multiple criteria -- Please Help!

Hello and welcome to the forum.

Try this in B1:

=LOOKUP(A1,E$1:E$6,D$1:D$6)

 

[Kbouz]

Re: IF formula multiple criteria -- Please Help!

thanks , but I need the result in column B to be level which in column D(1 or 2,or 3...) depending the the range I can copy the levels to column G if need be.

 

[Kbouz]

Re: IF formula multiple criteria -- Please Help!

thanks , but I need the result in column B to be level which in column D(1 or 2,or 3...) depending the the range I can copy the levels to column G if need be.

Sorry it worked!! thanks very much, I was sure this could only be done with IF. Thanks again

 

[63falcondude]

Re: IF formula multiple criteria -- Please Help!

You're welcome, glad to help.