Reference cost list

[Graham.Nova]

We have a excel spreadsheet we are making to generate quotes for our customers. We want to have a reference price list for our items so we can just enter a code number in one column and a quantity in another and based on the code it will look at the reference price list for the cost per item that matches that code and then multiply that by the quantity to give us a total.

Hopefully that makes sense. If not I'll try to come up with a better explanation.

I tried searching on google for how to do this, but I couldn't think of what to search for.

Thanks for any help!

Graham

[sandy666]

We have a excel spreadsheet we are making to generate quotes for our customers.

but we don't



Attach a sample workbook, not a picture. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Graham.Nova]

Ok I've attached a sample excel file that has two sheets.

Thanks!

[sandy666]

something like this?
=INDEX('Price List'!$B$3:$B$5,MATCH('Quote List'!E2,'Price List'!$A$3:$A$5,0))*F2

If you don't like #N/A you can use IFNA() or IFERROR()

[Graham.Nova]

Thanks for such quick responses.

I can't seem to download the file you attached. I get this message. "Invalid Attachment specified. If you followed a valid link, please notify the administrator"

I tried to input the formula you posted, but it didn't seem to work for me. I'm off for the weekend so I'll give this another go on Monday.

Have a great weekend!

[sandy666]

Refresh thread and try again

or here

[sandy666]

this is exactly for your example
C2: =INDEX('Price List'!$B$3:$B$5,MATCH('Quote List'!A2,'Price List'!$A$3:$A$5,0))*B2 and drag down

[Graham.Nova]

Thanks! I was able to download the excel file and this solves my issue.

My next question is how do I mark this thread as solved?

[63falcondude]

My next question is how do I mark this thread as solved?

Thread Tools at the top of this thread.

[sandy666]

Here is:

If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
If you did it - ignore it.
Thank you.