i have a master sheet with names in col A, dates in row 1, and a value at the intersect.
i would like to update this Master sheet from another sheet which is a dump from another programme.
i can do a vlookup to find the name in the update sheet, but that requires identifying the column matching the dates.
is there a way to not only lookup the name, but also the corresponding date?
i would like to update this Master sheet from another sheet which is a dump from another programme.
i can do a vlookup to find the name in the update sheet, but that requires identifying the column matching the dates.
is there a way to not only lookup the name, but also the corresponding date?