K
Kim
I have a reference table which contains multiple commission %'s in 21 columns
labeled with 3 letter codes; with rows of commission sources in column A.
Each commission source in column A has multiple %'s payable based on the
three letter code or type. I need Excel to look at a row on a daily data
sheet which contains a commission source in C and a three letter % code in F,
then go to the table, find the intersection of those two references and
return the valid % to the current data sheet. The ultimate purpose is to
recalulate the commission %'s received (daily data sheet) against contracted
%'s (reference table) and find variances based on commission source and type.
labeled with 3 letter codes; with rows of commission sources in column A.
Each commission source in column A has multiple %'s payable based on the
three letter code or type. I need Excel to look at a row on a daily data
sheet which contains a commission source in C and a three letter % code in F,
then go to the table, find the intersection of those two references and
return the valid % to the current data sheet. The ultimate purpose is to
recalulate the commission %'s received (daily data sheet) against contracted
%'s (reference table) and find variances based on commission source and type.