How do I use an IF statement to pick between two lists?
 

=IF(b60(first_list,second_list))

Doesn't work. I want to automatically use a list unless there's a value
entered in the field. If there is, I want to be forced to use the second
list.

How do I use an IF statement to pick between two lists?
 

Use a list to do what? It seems to me that you need to incorporate this
within a bigger formula.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Spatton17569" wrote in message
...
=IF(b60(first_list,second_list))

Doesn't work. I want to automatically use a list unless there's a value
entered in the field. If there is, I want to be forced to use the second
list.