![]() |
|
#1
|
|||
|
|||
|
I have a spreadsheet which has
Column A - List of Products we sell Column B - 2022 Prices Column C - 2023 Prices Column D - 2024 Prices i want to create a spreadsheet where the user work out how much the total product costs. In simple terms, if the User Selects 'Product A' and then '2022' - both drop down lists - then the result will be the price of the product in 2022, (answer from cell B2) if the User Selects 'Product B ' and then '2023' - both drop down lists - then the result will be the price of the product B in 2023 , (answer will be in cell C3) any ideas how I use VLoookup or similar in that way! |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help with lookup / v lookup big failure | mda99das | Excel | 4 | 11-04-2022 09:38 AM |
| User 1 cannot open Office files from File Explorer (it hangs forever); user 2 has no problem! | BillN | Office | 0 | 09-23-2020 08:55 AM |
| LOOKUP - Complex lookup with 2 lookups in 1 cell | sglandon | Excel | 6 | 05-05-2016 09:44 AM |
How can I prevent a User from changing the font format set by the Powerpoint template?
|
Ochimus | PowerPoint | 1 | 06-29-2015 04:53 AM |
| How can I get Outlook from one user to another w/o a .pst file (primary user on computer is corrupt) | Tenmakk | Outlook | 0 | 03-01-2015 12:49 PM |