Require help to pull figure base on +, - character.

[ExcelUser2707]

Hi All,

I want to pull data within the spreadsheet base on the positive and negative number.

Scenario

In sheet 3 I have pivoted data. Column “F” having number + ,- as material inward and outward. (Material numbers are unique)

Require result in sheet 4, Column “F” is inward and “G” is outward. If figure will positive it will consolidated in “F” and if figure is negative it will consolidate in “G”.

Sample sheet is attached for your reference.

Any help will appreciate.

Thanks in advance.

Regards

Amar K

[bebo021999]

May be
F4=MAX(0,VLOOKUP($B4,Sheet3!$A$1:$F$26,6,0))
G4=-MIN(0,VLOOKUP($B4,Sheet3!$A$1:$F$26,6,0))

[ExcelUser2707]

Hi BEBO,

It works very well, thanks for kindly cooperation, and sharing valuable information.

God bless you,

Regards

Amar K