ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Matching Values (https://www.excelbanter.com/excel-worksheet-functions/101482-matching-values.html)

shryockp

Matching Values
 
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

Matching Values
 
In cell A1, put the formula:

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

Regards

Trevor


"shryockp" wrote in message
...
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





All times are GMT +1. The time now is 06:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com