phantom1975
MrExcel MVP
- Joined
- Jun 3, 2002
- Messages
- 3,962
I have the following and it only works for the first condition:
=IF(A1={1,2,3,4,5},{11,22,33,44,55},0)
_________________
The only dumb question is the one that isn't asked. Pass on what you have learned.
This message was edited by phantom1975 on 2002-11-06 18:57
=IF(A1={1,2,3,4,5},{11,22,33,44,55},0)
_________________
The only dumb question is the one that isn't asked. Pass on what you have learned.
This message was edited by phantom1975 on 2002-11-06 18:57