This should be a simple problem to solve for anyone with experience with Mathcad, I wish I had the patience to figure it out for myself, but I don't.
I have an asset list made up of thousands of item numbers and there associated item costs, from this list I have been given a selection of item numbers of which I would like to determine there costs.
Could anyone provide me with a programme where I can input the list item numbers and their costs will automatically be found, im sure similar questions have been asked, so possibly you could direct me to link.
Agree with Mike. The lookup functions should do the job, I guess. Alas, we cannot be sure as long a we don't have a worksheet which shows the correct datastructure used, shows which version of Mathcad we are talking about, shows what exactly the output should be and shows the attempts you already made.
After all its a bit unclear what the function you are demanding should provide.
input a single part number, output the appropriate cost value
input a vector of part numbers, output a vector of the appropriate cost values
input a vector of part numbers, output the total sum of costs.
input a matrix of part numbers and number of items, output the total sum of costs.