Hello-- I am looking to begin a project that seems a little out of my realm. I was hoping for some help to get me started.
I work in an autobody shop that manufactures automobile parts. I have created a drop down list of cars and I am looking for a formula that assigns a different money value in a different cell to each car chosen from the drop down list.
I think that this is probably a simple formula, but I am a novice and haven't been able to locate anything on the web. Any help at all would be much appreciated!
How will you determine the value to assign? Is it in another table with an association to the car type. Explain your logic and we will help you to achieve your solution. But without the details, we don't know what is in your spreadsheet.
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
For discussion:
Cell A1 contains the drop down list
Cells G1:H10 is a table of values, where column-G cells contain the list of car type and column-H cells contain the cost.
Using cell B1 as the formula cell to return the matching cost based on the selection in cell A1, this formula:
=VLOOKUP(A1,$G$1:$H$10,2,0)
See this page for help on VLOOKUP
Note: the look up table can reside on a separate worksheet and be comprised of as many columns as needed.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks