Trying to get get result from 2 diff excel sheet

bobby - Mar 17, 2015 at 02:05 PM

I am trying to create an Pivot table, but for that I want to run a coumn which gets me the result from putting the IF function from one excel sheet and puting the "<" sign from the data in the other excel sheet.

Something like this ( AB < BI ( this if from diff excel sheet, where it already contains its own IF function for that column )

The end result should be ( AB < BI = Before/After )

I am so confused with this !