Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-09-2022, 02:26 PM
maw444 maw444 is offline Looking up a value with user changing the lookup coloum Windows 10 Looking up a value with user changing the lookup coloum Office 2019
Advanced Beginner
Looking up a value with user changing the lookup coloum
 
Join Date: Feb 2021
Posts: 40
maw444 is on a distinguished road
Default Looking up a value with user changing the lookup coloum

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!
Reply With Quote
 



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
Looking up a value with user changing the lookup coloum 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft