In D1 enter =IF(C1="x","Theatre",""), and copy down as far as
needed/anticipated.
"JPriest" wrote:


I'm trying to use an If statement to complete a form. I'm trying to pull
the text from column c and insert the corresponding info into column d.
for example: if the show is 'x' in column c, then insert 'theatre' in
column d. However, because the text is coming from a drop down list in
column c, i keep getting an error returned. There is no way to sort the
shows in column c because they are arranged based on time, which also
changes, not their title.

Any help you could provide would be greatly appreciated.

Thank you in advance,
Jeff


--
JPriest
------------------------------------------------------------------------
JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695
View this thread: http://www.excelforum.com/showthread...hreadid=539397