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

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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...

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

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

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


Gord Dibben MS Excel MVP

On Thu, 8 May 2008 04:08:02 -0700 (PDT), 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