Auto populating field determined by previously input details

[Newton1234]

Hi,

I was wondering if anyone can help solve a porblem I am having on an excel spreadsheet we use for cash details.

We input the currency from a drop down list, enter the account number (which autopopulates the account name from a VLOOKUP). But the problem comes in with the Bank Pool details.

We have a different Pool number depending on the account number and the currency. So there are hundreds of pools to choose, so I have been asked to auto populate the field, determined by the account name and currency.

I have attached a mock up spreadsheet, I need a formula for cell B20.

Please let me know if you need anything further or any more explaination is required.

Thanks in advance for any help I can get.

[rylo]

Hi

What is the bank pool, and where does it come from? Is it 569214?

If so then try

Please Login or Register  to view this content.

rylo

[Newton1234]

Hi Rylo,

Thanks very much for your reply and this is partly what I require. The Bank Pools are cells D2:D7, F2:F7, H2:H7 etc..

However I require the full box name to show in cell B20, eg. CAD 569214

Is this possible ?

Thanks again

[rylo]

Hi

If you want the full result then try

Please Login or Register  to view this content.

rylo

[Newton1234]

Thank you very much, that has worked :-)