VLOOKUP syntax HELP!

[Alien]

=IF(L10>0.9,IF(L10<9,1.06,VLOOKUP(L10,$AD$1:$AE$9,2)))
currently the above vlookup, looks up the criteria of some letters.

I want it to do the lookup if the value of cell L10 is from 1 to 9.

I tried fudging it and got a False. So I am asking the smart guys!
Tia

 

[Alan Beban]

The details of what you are trying to do are not entirely clear, but the
following will return the value from the lookup if L10 contains a value
between 1 and 9, inclusive, and 1.06 otherwise:

=IF(AND(L10>=1,L10<=9),VLOOKUP(L10,$A$1:$B$9,2,FALSE),1.06)

Alan Beban

 

[Alien]

Thank YOU Alan, that returned the exact answer I was looking for.
The 1.06 is no longer needed and I do not need a default answer.
How would you leave it out?
Thanks again!

 

[Alien]

Thank YOU Alan, that returned the exact answer I was looking for.
The 1.06 is no longer needed and I do not need a default answer.
How would you leave it out?
Thanks again!

 

[Alien]

Thanks Alan that returned exactly what I wanted.
the 1.06 is not needed and I do not even remember why it's there
I do not need any type of "default" value. how would you write the
same formula without the 1.06 default value?
Thank You for your help!!!!

 

[Alan Beban]

Just change the 1.06 to ""

Alan Beban

Thanks Alan that returned exactly what I wanted.
the 1.06 is not needed and I do not even remember why it's there
I do not need any type of "default" value. how would you write the
same formula without the 1.06 default value?
Thank You for your help!!!!