# formula help (just not sure what ALL help)

#### lisach

##### New Member
First let me say I have found my new hang out spot!!! After watching several of the UTube videos on Excelisfun channel I know I need to watch ALL 1,600 videos!! However in the interest of getting my work done before Christmas 2012..... I need some help with 2 different formulas. I have spent many hours trying to determine the best way to do this.

I have 2 sheets.
1. Current Inventory
a. Column A has a list of chemicals
b.
Column B current lbs on hand
c.
Column C cost per lb
2. Inventory transactions​
a. Column A has a list of chemicals
b.
Column B has lbs purchased or sold
c.
Column C has the purchase price
Working from Sheet 1 Current Inventory
1. From Sheet I want to extract new records from sheet 2 and add them to column A displaying newly purchased items. Can you keep this list sorted in alphabetical order dynamically???

· Working from Sheet 1.
I want to look up the chemical name from A1 in sheet 2. If it exists:​
a. I want to add (purchases) or subtract (sales) the number from cell B1 in sheet 2 to cell B1 in sheet 1 Inventory. This does need to be dynamic. The same chemical will be purchased and sold many times.
b. If this is true I want to display the number from sheet 2 Cell C1 (purchase price) but ONLY if it is greater than the current value.
I will in the mean time be watching more videos!!

Lisach

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Replies
1
Views
311
Replies
1
Views
187
Replies
1
Views
854
Replies
9
Views
1K
Replies
1
Views
917

1,207,255
Messages
6,077,311
Members
446,278
Latest member
hoangquan2310

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