#### disharpe726

##### New Member
Hi, I have looked everywhere and I cannot figure out how to do what I need to do. It may be simple, but please let me know if you can help. I have a drop down menu to select a type of transaction in Column A. In Column B i have an amount. On another work sheet I have an Income Statement. I need the amount in Column B to flow through to the Income Statement. Therefore, I need a function that will look up what type of transaction it is (column A) and return the amount in column B. All I can find are functions that look up and return the same amount. Thanks in advance if you have any advice on what to do.

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Replies
2
Views
410
Replies
1
Views
369
Replies
1
Views
594
Replies
5
Views
172
Replies
2
Views
355

### Forum statistics

1,196,448
Messages
6,015,324
Members
441,889
Latest member
balolaptopgiaolong

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