Drop Down box & Correct answers

Risque666

New Member
Joined
Nov 23, 2019
Messages
28
Office Version
  1. 2016
Platform
  1. Windows
Hi All.

I am trying to have a Drop down box which I can make and then have a list of Phone numbers to go with it.
Example:

Dropdown box has bank names - cell under it is the corresponding Phone number.
So what i need help with is making sure that when I say click the drop down box and choose westpac bank. The Correct phone number appears in the cell below.
Can anyone shed some light on this please as per below is an example

Westpac
1800 westpac

If i choose ANZ
it would bring up ANZ phone number

ANZ
1800 ANZ

Thanks
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Risque666

New Member
Joined
Nov 23, 2019
Messages
28
Office Version
  1. 2016
Platform
  1. Windows
Still wanting help with this but now also wanting it so that when I choose the Bank name from the drop down box, the cell below it gives me the correct number as well as the cells on A10 to A15 give me the details that particular bank needs.

Example.

Drop down Box = Westpac
Cell below = Westpac number

Cell A10 = Customer name
Cell A11 = Customer Card Number
Cell A12 = Card Expiry
Cell A13 = Transaction amount


But if I chose ANZ it would be.

Drop down box = ANZ
Cell below = ANZ number

Cell A10 = Customer Name
Cell A11 = Date of Transaction
Cell A12 = Transaction Amount
Cell A13 = Post code of Guest.

Does anyone one have any advise please
 

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,565
Office Version
  1. 365
  2. 2010
Something like the following? You could also put the bank data I have in G-L on a separate sheet.

Book24
ABCDEFGHIJKLM
1Choose a BankWestpac555-123-5555Joe12345678910/23/2021$500.0020111
2BOCANZ858-678-1234Mary98765432112/15/2021$1,000.0092122
3Phone: 212-888-1000BOC212-888-1000Fred55544466661/31/2021$2,500.0055601
4
5
6
7
8
9
10Fred
111/31/2021
12$2,500.00
1355601
Sheet1
Cell Formulas
RangeFormula
A3A3="Phone: "&VLOOKUP(A2,G1:H3,2,FALSE)
A10A10=VLOOKUP($A$2,$G$1:$M$3,3,FALSE)
A11A11=VLOOKUP($A$2,$G$1:$M$3,5,FALSE)
A12A12=VLOOKUP($A$2,$G$1:$M$3,6,FALSE)
A13A13=VLOOKUP($A$2,$G$1:$M$3,7,FALSE)
 

Risque666

New Member
Joined
Nov 23, 2019
Messages
28
Office Version
  1. 2016
Platform
  1. Windows
Yes ty something like that but I just want it to bring up the headings for the Cells A10 - A13
Plus the cells would need to be different dependant on the bank the Customer banked with.
the actual guest details we will fill out manually.
 

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,565
Office Version
  1. 365
  2. 2010
I don't understand your reply comment. Need to be clearer or illustrate what you want.
If I gave you the foundation, can you modify for what you need?
 

Watch MrExcel Video

Forum statistics

Threads
1,127,098
Messages
5,622,678
Members
415,921
Latest member
ExcelNoob28

We've detected that you are using an adblocker.

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.
Go back
Top