Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hello! I need help with a formula. I have two Sheets - Sheet 1 (Product Info) & Sheet 2 (Order Calculations). In Sheet 1, there is a range for the Products (e.g. A1-20), as well as the prices by product and size (e.g. for Small prices S1-20, for Medium prices, M1-20, for Large prices L1-20). In Sheet 2, I have a few drop down options: For example, "Product Type" with a dropdown of all A1-20 items. Then I have a field with the Size options, so the dropdown has "S", "M" and "L". If I want a formula in Sheet 2, depending on the dropdown of "Product Type" (A1-20) & "Size" (S/M/L), how do I make it take the correct information from Sheet 1?
Solved by I. E. in 26 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 26/03/2018 - 11:35
Excelchat Expert 26/03/2018 - 11:35
can you please share the file?
User 26/03/2018 - 11:35
Hi there! Thank you for getting back to me.
User 26/03/2018 - 11:35
It's sensitive information unfortunately, but I can replicate the most important parts pertaining to my question?
Excelchat Expert 26/03/2018 - 11:36
thanks, please do so
User 26/03/2018 - 11:40
So, essentially what I'm looking for when looking at the formula for "Price" in Sheet2, is how to make Google Excel draw data depending on the drop down input from Product Type & Size in Sheet2
User 26/03/2018 - 11:40
With the example I input in A2 and B2 of Sheet 2, with the formula I am looking for, C2 on Sheet2 would automatically input 19 (from Sheet1)
Excelchat Expert 26/03/2018 - 11:42
okay sure
User 26/03/2018 - 11:43
Thank you for your help. I am not sure how to go about this with a formula
Excelchat Expert 26/03/2018 - 11:48
wait a bit
User 26/03/2018 - 11:48
For sure, thanks~
Excelchat Expert 26/03/2018 - 11:53
[Uploaded an Excel file]
User 26/03/2018 - 11:54
Thank you!
Excelchat Expert 26/03/2018 - 11:54
User 26/03/2018 - 11:54
I'm not sure if it works though. I tried selecting form the drag and drop for the row beneath, and it gives an #N/A ? :S
Excelchat Expert 26/03/2018 - 11:55
wait let me see
User 26/03/2018 - 11:55
Excelchat Expert 26/03/2018 - 11:59
[Uploaded an Excel file]
User 26/03/2018 - 12:00
Thank you so much!! It works! :)
User 26/03/2018 - 12:00
Thank you very, very much!
Excelchat Expert 26/03/2018 - 12:00
most welcome
Excelchat Expert 26/03/2018 - 12:01
User 26/03/2018 - 12:01
Have a great day!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc