You'll find sure limits with employing VLOOKUP—the VLOOKUP operate can only lookup a value from remaining to proper. Which means that the column made up of the value you look up should really always be Found towards the left on the column that contains the return benefit.To refresh facts on file open up Select to obtain Excel refresh PivotTable i