excelnewvbie
New member
- Joined
- Jan 18, 2017
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hi Guys,
I am new to this forum and quite new to Excel and I would really appreciate your expert help. I have tried my best youtubeing and googlein but have come to a dead end since I dont even know what I am really looking for Tables, lookups, matches? Dunno anymore.
Scenario: I have a big-big stash of computer-parts and other electronics that I am going to sell. I have a price tag on everything in my excel list. When a buyer contacts me I want to use a conditional dropdown list to get to the pricetag without having to scroll my fingers off.
I have attached a best-I-can-do template in the thread. Basically I want to be able to get the price by choosing options in the dropdown menus.
What I would like Excel (and you of course) to help me with is: If I choose i.e "Nvidia" - "GPU" - "1 year" from dropdownmenus in sheet1, excel gets info "IF brand=Nvidia AND product type=GPU AND age=1 year;; THEN get price from sheet 3 list to new free cell.
Hope you have a slight clue about what I mean.
Thank you everybody!
I am new to this forum and quite new to Excel and I would really appreciate your expert help. I have tried my best youtubeing and googlein but have come to a dead end since I dont even know what I am really looking for Tables, lookups, matches? Dunno anymore.
Scenario: I have a big-big stash of computer-parts and other electronics that I am going to sell. I have a price tag on everything in my excel list. When a buyer contacts me I want to use a conditional dropdown list to get to the pricetag without having to scroll my fingers off.
I have attached a best-I-can-do template in the thread. Basically I want to be able to get the price by choosing options in the dropdown menus.
What I would like Excel (and you of course) to help me with is: If I choose i.e "Nvidia" - "GPU" - "1 year" from dropdownmenus in sheet1, excel gets info "IF brand=Nvidia AND product type=GPU AND age=1 year;; THEN get price from sheet 3 list to new free cell.
Hope you have a slight clue about what I mean.
Thank you everybody!