# Formula Help

#### Travisallen2007

##### New Member
I have two tables and need Table A (Which is changeable) To source its data off table B. I am not sure how to set this up and any help would be greatly appreciated.

Table A
A23:A31 is changable Word corresponding to cash amounts. Drop down based on table at E53:F60 (Also now called table B)
B23:B31 Is where the user types in quantities of the dollars they have
C23:C31 is where i need it to calculate to dollar value from Table B associated with the choice they selected in A23:A31 multiplied by B23:B31

Table B:
E53:E60 is the titles of the drop downs that will be selectable for A23:A31 (With one exception listed below)
F53:F60 is the dollar amounts that need to be used based on the selection chosen in table A A23:A31 and later used to multiply showing total dollar amount in cells C23:C31

The only exception to this is for pennies, nickels, dimes and Qtrs that never change. Pennies are always .50, Nickels always 2, dimes always 5, and quarters always 10.

Thanks again for any help!! Really appreciate it!

.

Last edited:

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

#### Fluff

##### MrExcel MVP, Moderator
Oops, missed a bracket
=B23*IF(ISERROR(VLOOKUP(A23,\$E\$53:\$F\$60,2,0)),0,VLOOKUP(A23,\$E\$53:\$F\$60,2,0))

#### Travisallen2007

##### New Member
That worked perfect! Thank you so much for all your time today!! Really appreciate it!

Last edited:

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback.

Replies
2
Views
83
Replies
0
Views
77
Replies
5
Views
419
Replies
3
Views
557
Replies
14
Views
717

### Forum statistics

1,127,405
Messages
5,624,574
Members
416,036
Latest member
eloisa manzanarez

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

### Which adblocker are you using?

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

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