There are selected restrictions with applying VLOOKUP—the VLOOKUP function can only look up a worth from still left to proper. Which means that the column that contains the worth you lookup really should always be Positioned to your still left in the column containing the return benefit.To refresh facts on file open Find to own Excel refresh Pivo