Depending on the hierarchy in the fields, rows might be nested inside rows which might be higher in situation.To refresh details on file open up Pick to acquire Excel refresh PivotTable knowledge every time the file is opened.Looks up "B" in row 1, and returns the worth from row 3 which is in a similar column. Simply because a precise match for "B"