| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
| IF statement with lists and dropdowns | Excel Worksheet Functions | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| Comparing 2 Customer Lists to Identify Shared Customers | Excel Worksheet Functions | |||
| Using Pick Lists | Excel Worksheet Functions | |||
Linear Mode
