# Drop Down box & Correct answers

#### Risque666

##### New Member
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

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### Risque666

##### New Member
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
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
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
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?

Replies
0
Views
45
Replies
6
Views
143
Replies
6
Views
184
Replies
22
Views
436
Replies
0
Views
117

1,127,328
Messages
5,624,036
Members
416,007
Latest member
csf

### 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?

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