As part of the bank reconciliation process I'm allocating bank transactions to relevant departments on a monthly basis (so they know to investigate). When I run a tranx list for a new month some of the original transactions remain, as well as new additional ones for the month. As I've already allocated a dept to those transactions from the prior month, I want to use a Vlookup to do this. For any new transactions, I want to use the data validation list function to select from a list of departments. See below simplified example:</SPAN>
1</SPAN>
A</SPAN>
B</SPAN>
C</SPAN>
D</SPAN>
E</SPAN>
2</SPAN>
May</SPAN>
April</SPAN>
3</SPAN>
Transaction ID</SPAN>
Department</SPAN>
Transaction ID</SPAN>
Department</SPAN>
4</SPAN>
5</SPAN>
1</SPAN>
1</SPAN>
Accounts Payable</SPAN>
6</SPAN>
2</SPAN>
2</SPAN>
Payroll</SPAN>
7</SPAN>
3</SPAN>
3</SPAN>
Treasury</SPAN>
8</SPAN>
4</SPAN>
9</SPAN>
5</SPAN>
10</SPAN>
11</SPAN>
12</SPAN>
List:</SPAN>
13</SPAN>
Accounts Payable</SPAN>
14</SPAN>
Payroll</SPAN>
15</SPAN>
Treasury</SPAN>
16</SPAN>
Accounts Receivable</SPAN>
17</SPAN>
Management Accounting</SPAN>
I know transactions 1,2,3 are Accounts Payable, Payroll and Treasury respectfully and can therefore us a vlookup to return these values. However, for transactions 4 & 5, i wish to use a drop-down list from the list of departments (A12:A17)</SPAN>
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.