"IF" and "LOOKUP"

[SSgt]

I think... It might be "IF" and "INDEX" ...that's part of my problem.

I have a costing bid sheet that I have set up to find the cheapest option and list the vendor (the first chart). I am trying to use that list to generate a purchase order automatically, and I can't figure out how to select a row of data based on the response to the "vendor" cell. I would like it to work by searching the first chart for the vendor name on that is listed on the PO(the last chart), add the data associated for that row, and then repeat for every instance of that vendor name.

It's hard to explain - there is a copy attached. FILE DELETED - RESUBMITTED IN POST #4

Once I figure that out, I would also like to get the Order Amount from the second chart to auto-pop too....but I'll work on that when I get to it.



(this is for school - the data is made up. The focus of the assignment is costing and understanding when to reorder supplies. We are supposed to hand-jam it, I'd rather use an easy assignment to learn how to use my tools better)