Combine List with a Vlookup

[mcable01]

Hi!

Is it possible to use a vlookup formula and, if no value is located, select from a drop-down list within the same cell?

Not sure if this is possible.

Hope this makes. Let me know if you need any other info.

Cheers!!

M

 

[Aladin Akyurek]

Woud you elabarate by way of an example?

 

[mcable01]

Sure, Ill try!</SPAN>
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>
Hope this makes sense!</SPAN>
Thanks for you help regardless..</SPAN>
M</SPAN>

<TBODY>
</TBODY><COLGROUP><COL span=7></COLGROUP><TBODY>
</TBODY>

 

[Aladin Akyurek]

Why not choose each either from a dropdown list or via a look up formula?

Mixing would be possible if

=IFERROR(VLOOKUP(TransctionID,Table,2,0),DataValidationCell)

I don't think this is maintenable.