|
What is looks like you want to do is a "lookup" or "vlookup" or "hlookup". Real quick what that does it based on what is entered in a cell excel is told to find that value in a range then return what is finds in a cell or row. You could then do the qty*price piece
Don't really have the time to work it out for you but you can if info in excel under those terms. If you have a problem (took me a bit before I "got" it way back when) I will be around over the weekend.
L.
|