Vlookup returning more than one result
Dear all,
please i need your help in solving the below problem:
I am preparing a report to summarize the Shortage amount for every employee
in each of the 3 items that we are selling to customers
Sheet 1: Item1 shortages as follow Staff ID Shortage amount
Sheet 2: Item2 shortages as follow Staff ID Shortage amount
Sheet 3: Item3 shortages as follow Staff ID Shortage amount
I need a function to consolidate in sheet4 the shortage for each one of the
staff in the 3 items
Sheet4:
Staff ID Item1 Item2 Item3
xxx xxx xxx xxxx
BR,
Khaled
|