Hello,

I consider myself a basic user of excel. I am well versed in many coding languages.(html/css/java etc) I can setup data tables, simple formulas (some complex =if), make calculations that sort of thing.

I have recently been tasked with setting up an estimation spreadsheet for our company. Basically we have our suppliers price list, with item description, name, cost, delivery etc.; from 3 different suppliers.

I can get those tables setup and can manually on a separate table assemble my quote/estimate by clicking =and click the direct cell.

What I would like to do is be able to enter a product code from one of those lists and have it show up in the estimate sheet. eg. Code 1001 12 yds topsoil $197.

Is this possible with Excel Mac 2011. Is it beyond my learning capability.

I thank you for your time in responding.