Showing a specific value in one field if another field contains data

**kbenderil** · 02-17-2012, 04:10 PM

I want a cell on one worksheet to show a specific value of "None" or "Request Made" if a specified cell in another worksheet is empty or conversely, contains data. How do I do this?

**TMS** · 02-17-2012, 04:16 PM

=IF(Sheet2!A1="","None","Request Made")

Regards, TMS

**kbenderil** · 02-20-2012, 03:35 PM

Thanks TMS! Problem solved. You're great!

**TMS** · 02-20-2012, 04:00 PM

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save