Hi All,
i struggled with the title for this question... sorry.
What i'm trying to do is to set a freight value from a table of variables. I have a multi page workbook where page 1 is all the variables we need to consider.
Column 1 on all other pages lists product category A to H, what i want to do is have my freight calculation to read the column 1 value (a-h), then lookup that value on my variables page to apply the freight value in $
I hope i have explained that well enough...
i struggled with the title for this question... sorry.
What i'm trying to do is to set a freight value from a table of variables. I have a multi page workbook where page 1 is all the variables we need to consider.
Column 1 on all other pages lists product category A to H, what i want to do is have my freight calculation to read the column 1 value (a-h), then lookup that value on my variables page to apply the freight value in $
I hope i have explained that well enough...