I am trying to come up with a way to use the Prod. Code and Pkg information on the pricing tab to bring in the corresponding margin from the margin tab. For example, I'd like the program to bring in $124 into cell K5 on the pricing tab (program looks up or matches that Prod code of 3890 with Pkg of 200 lb Bio and finds the $123 in cell E2 on the Margin tab). I have suspect that a combination of MATCH, AND, IF and perhaps a Vlookup will get the job done but I have been unsuccessful in my attempts and would greatly appreciate any and all help.
tpk working sheet.xlsx
Bookmarks