Master in Excel help me with a formula

J

j.sarwal

I need a formula that can help me do this:

If I am typing 234 in B3 and 456 in B4. I want to add a formula that
automatically enters sweet and honey in C3, C4cell.

234 Sweet
456 honey

When i enter 234 in B3 cell then in C3 it should automatically select
Sweet.

It will be very helpful if you can help me with this please let me
know.

Thanks
 
M

Mike H

Maybe this in C3
=IF(B3=234,"Sweet","")
and this in C4
=IF(B4=456,"Honey","")

Mike
 
G

Gord Dibben

In C3 enter =IF(B3=234,"Sweet","sour")

In C4 enter =IF(B4=456,"Honey", "bee")


Gord Dibben MS Excel MVP
 
Top