johanexcel
New Member
- Joined
- Jun 20, 2015
- Messages
- 1
Dear all,
I would like to request some help with creating a formula.
I have 1 data sheet with account numbers (column A) and departments (Column B). Not all account numbers are available with all departments.
<tbody>
</tbody>
In the input sheet (which will be completed manually) I would like to have a control to see if the combination of account number and department is a valid combination. What formula could I use?
Many thanks in advance for your expertise!
Johan
I would like to request some help with creating a formula.
I have 1 data sheet with account numbers (column A) and departments (Column B). Not all account numbers are available with all departments.
Account | Department |
4000 | 15 |
4000 | 16 |
4000 | 21 |
4001 | 15 |
4001 | 17 |
4001 | 20 |
<tbody>
</tbody>
In the input sheet (which will be completed manually) I would like to have a control to see if the combination of account number and department is a valid combination. What formula could I use?
Many thanks in advance for your expertise!
Johan