# Lookup help

#### Jettfactor

##### New Member
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?

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
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

Last edited:
Thank you, worked great!

Last edited:
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"))

Let me know how the following goes:

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

Regards,

Robert

Replies
4
Views
128
Replies
1
Views
174
Replies
9
Views
216
Replies
19
Views
573
Replies
1
Views
47

1,207,012
Messages
6,076,147
Members
446,187
Latest member
LMill

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back