VLOOKUP syntax HELP!

  • Thread starter Thread starter Alien
  • Start date Start date
A

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
 
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
 
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!
 
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!
 
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!!!!
 
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!!!!
Click to expand...
 
Back
Top