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

Mike

" wrote:


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