Example: I want to be able to display "Cathy's Check" in cell G4 by typing
the number "2" in cell B4 but I also want to display "John's Check" in cell
G4 by typing the number "3" in cell B4 as well. Can some one help me please!

=IF(G4=2,"Cathy's Check", if(G4=3,"John's Check" ,"")

This is display nothing if G4 is other than 2 or 3
If the list gets longer, a lookup function would be appropriate.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"John C." <John wrote in message
...
Example: I want to be able to display "Cathy's Check" in cell G4 by typing
the number "2" in cell B4 but I also want to display "John's Check" in
cell
G4 by typing the number "3" in cell B4 as well. Can some one help me
please!

Use an IF statement in G4:

=IF(B4=2,"Cathy's Check",IF(B4=3,"John'sCheck",""))
--
Gary''s Student - gsnu200773


"John C." wrote:

Example: I want to be able to display "Cathy's Check" in cell G4 by typing
the number "2" in cell B4 but I also want to display "John's Check" in cell
G4 by typing the number "3" in cell B4 as well. Can some one help me please!

Try this in G4

=CHOOSE(B4,"","Cathy's Check","John's check")

Mike

"John C." wrote:

Example: I want to be able to display "Cathy's Check" in cell G4 by typing
the number "2" in cell B4 but I also want to display "John's Check" in cell
G4 by typing the number "3" in cell B4 as well. Can some one help me please!