Need a formula to distribute an amount to specified fields

[beth.randall]

I have a spreadsheet and in column A I have letters and in column B I have an amount. Each letter has a designated amount associated with it. I change the amounts of each letter on a weekly basis. I want to have a "legend" of sorts to enter new amounts for the letters and this amount would auto-populate to all the corresponding Letters throughout the spreadsheet.

Example:

E 22.01
F 56.38
GC 8.28
B 96.35
T 0.98
F 56.38
F 56.38
GC 8.28
B 96.35
B 96.35
B 96.35
B 96.35
F 56.38
F 56.38
E 22.01
E 22.01
E 22.01

[FDibbins]

Welcome to the forum

If you already have a "legend" for your letters and corresponding values, then all you need to do is use a vlookup to return the associated value

Something like =VLOOKUP(A2,$J$1:$K$26,2,0), copied down

where J1:K26 is the range of your "Legend" - adjust as needed

[beth.randall]

That formula brought back the amount within my spreadsheet. I need kind of the reverse of that. I want to enter the amount in the legend and that amount be distributed to the spreadsheet below. Or maybe I did it wrong.