If Statements in a list

Giganews Newsgroups
Subject: If Statements in a list
Posted by:  JPriest (JPriest.27codn_1146858902.3988@excelforum-nospam.com)
Date: Fri, 5 May 2006

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,

JPriest's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=24695
View this thread:http://www.excelforum.com/showthread.php?threadid=539397