I am trying to create a CRM for my business, using excel.


I have a drop down box with my services listed. I want to also have the corresponding price listed in the next column. I have read about VLookup but i am not to savvy with formulas. Can anybody give me a quick walkthrough?
I have uploaded a portion of my spread sheet.
Thanks

Attached Files

Retro Data CRM.xls (47.5 KB, 11 views)

I took a look at your file. I added Data Validation to give you the pick lists for your itemized costs column (on the Data tab).

I updated the Unit Price column to use a vlookup to get the corresponding price.

I added an IFERROR wrapper to the unit price and amount columns to get rid of those #value indicators.

The attached file is a working version.

Hope this helps you out.

Charlie

Attached Files

Retro Data CRM - updated.xls (48.5 KB, 13 views)

Thanks, I appreicate you getting back to my question.
That is exactely what I was looking for. I will look at the way you setup the formula and try to understand it.

Thanks Again.