#1
|
||||
|
||||
Excel: Item and Price
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 |
#2
|
|||
|
|||
Added Data Validation, VLOOKUP, and IFERROR
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 |
#3
|
||||
|
||||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I am currently using Office Pro 2010 Is it worth the price to purchase Office 2013? | thousman | Office | 1 | 05-15-2014 04:51 PM |
Yearly price escalator? | markg2 | Excel | 1 | 04-15-2012 01:47 AM |
Item Already updated | simon@resultsoftware.co.u | Outlook | 0 | 07-25-2011 04:30 AM |
Insert an item to excel specific cell | apjneeraj | Excel | 0 | 01-18-2011 03:39 AM |
how to change the settings of sent item | Dhaval | Outlook | 1 | 10-09-2010 03:18 PM |