Master in Excel help me with a formula

[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

 

[Mike H]

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

Mike

 

[Don Guillett]

Have a look in the help index for VLOOKUP. Make a table and use that.

 

[Gord Dibben]

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

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


Gord Dibben MS Excel MVP