Hi All,
I have a pivot table which looks at my stock file, and report how many items
in stock, the Parts(ID) are classified as WI prefix for Work in Progess and
FG for Finished Goods, I use a Vlookup function from a database giving me a
two prices for the part, I use one column for WI and another for FG items,
times the quantity in stock from the Pivot table. What I require is an IF
statement that if the part is prefixed WI no value is returned in the FG
column and if FG prefixed no value is shown in the WI column, so the columns
can be totaled for their respective values.
TIA
regards
Roger