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
hello
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
here
[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
Thanks~
Excelchat Expert
26/03/2018 - 11:59
HERE
[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.