Matching Values

[shryockp]

Ok, here's a complex one. If a specific value is entered in column B1, "8536"
for example, I'd like a message such as "Pieces Needed" to pop-up in A1. Any
thing you can do to help would make life so easy. Thanks

 

[Trevor Shuttleworth]

In cell A1, put the formula:

=IF(B1="","","Pieces Needed")

Regards

Trevor