Lookup help

[Jettfactor]

I need help with a lookup problem if possible. This is what I have but doesn't work.

=LOOKUP(BD9<>BE9,{"Under";"Even";"Over"})

So what I need is if BD9 is less than BE9 it will say Over and if BE9 is greater than BD9 it will say Under and if the two are the same it would say even. Is this possible?

 

[Trebor76]

Hi Jettfactor,

The following formula* should do the trick - just note as you haven't said what to return if BD9 is greater than BE9 the formula will currently return "Even" in this instance:

=IF(BD9 < BE9,"Over",IF(BE9 > BD9,"Under","Even"))

HTH

Robert

* Remove the spaces around the "<" and ">" signs

 

[Jettfactor]

Thank you, worked great!

 

[Jettfactor]

I think I need one more step here, I would like "Even" to compare the two in the below if the two columns are even it says "Under" so is there a way to add to the below so if the two are equal it will read "Even"?

=IF(BD9 < BE9,"Over",IF(BE9 > BD9,"Under","Even"))

 

[Trebor76]

Let me know how the following goes:

=IF(BD9=BE9,"Even",IF(BD9 < BE9,"Over","Under"))

Regards,

Robert