![]() |
#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! |
|
![]() |
||||
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 |
![]() |
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 |