I want to look up values in the blue boxes in the attached sheet.
Items are sold to three market types - under two different price settings. How to look up say for a specific item [sk1] so that both columns under a market type is shown.
Like look up (sk1) returns only prices for a specific market. I tried to create named ranges but how this could be achieved?
Invoice table will show the two price sets :( p1 and p2) for only those items that corresponds to a specific item and a specific market type.
invoice2 sk1 conventional market $ 45.00 $ 50.00
What formula can be put in those two blue boxes to do this?