Good Morning,
I don't know how to best explain it so hopefully my the picture might do a better job at explaining.
Process: Invoice with Item List without Price; Must create a new invoice to reflect the correct prices
Goal: Create a new invoice based on Item List + Price based on Region.
My set of data will be like this:
What I am thinking how to translate (and this is where I need help):
The first table (Lets call it A-Table) will be the source of the invoice without pricing. I would like the next table (Lets call it B-Table) to pickup information from the A-Table to match the Item list with the corresponding Price based on Region. I was thinking of creating a drop down list where one would select the Region, and a formula can pickup the selection on the drop down list, and populate the respective price and matching the Item List.
I would appreciate some help as my head hurts thinking how to combine them all, or simplify the method.
Regards,
B.
I don't know how to best explain it so hopefully my the picture might do a better job at explaining.
Process: Invoice with Item List without Price; Must create a new invoice to reflect the correct prices
Goal: Create a new invoice based on Item List + Price based on Region.
My set of data will be like this:
What I am thinking how to translate (and this is where I need help):
The first table (Lets call it A-Table) will be the source of the invoice without pricing. I would like the next table (Lets call it B-Table) to pickup information from the A-Table to match the Item list with the corresponding Price based on Region. I was thinking of creating a drop down list where one would select the Region, and a formula can pickup the selection on the drop down list, and populate the respective price and matching the Item List.
I would appreciate some help as my head hurts thinking how to combine them all, or simplify the method.
Regards,
B.