Creating Lookup Formula Using 3 Drop-Down Selections

[Kubson]

Hello ,

I stuck with excel formula vlookup + match in my file . I am try to make calculator in excel sheet and I stuck .

Goal :
- I want to have 3 fields with drop down list
- In each field from drop i choose option that i want
- behind each option in other sheet i hide price
- if I choose something in option 1 , 2 , 3 I want from excel to sum for me this price in field below.

Problem:
- I use this formula =VLOOKUP(Kalkulator!$C$9,pompy!B5:F15,1+MATCH(Kalkulator!$I$9,pompy!C4:F4,0),0)
and this formula is okey only for sum prices from option 1 and 2 but I dont know how to change formula to make it work for sum all three options .

Is quiet important to me . I very appriciated for your help to figure out this one .
There should be attached excel file with this
Thanks!

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have done it for you this time.)

[AliGW]

OK - I've had a look and I am perplexed. Please could you give us some directions? Where in the workbook are:

1. The formula you've tried.
2. The drop-down selector boxes.
3. The expected results that you have mocked up to show us what you want.

[JohnTopley]

How does the second table (C18:F25) relate to the first (C5:F15) ?

You select "BUFOR300" (Column Heading) but how do we/you know which ROW (Bufor1 to Bufor 8) this relates to?

[Kubson]

Present situation :

I make some draft version of file which will be used as handy calculator for me as a sellsman .

In this file which I attached there are two visible sheets named "kalkulator" , "pompy" in there are hidden prices and names for each drop down list.

In "kalkulator" sheet I got fields named :
- "choose model" which attached drop down list with names from sheet pompy B5:B15
- "choose size" which attached drop down list with names from sheet pompy C4:F4
- "choose option" which attached drop down list with names from sheet pompy C17:F17
- "Your cost is netto" in this field I want to sum prices from three fields above depending on which option I will select in each field above.

Right now I manage to sum only two fields "model" and "size" by using formula vlookup + match .

Prices for field "choose option" are in sheet "kalkulator" as Bufor 100 , 200 , 300 , 400

Problem :
How to sum this three fields "model" , "size" , "option" ( depending o what i pick from list ) "into your cost is netto field"

I try to use this vlookup + match formula to link or three fields to sum "prices to your cost is netto" but is not working and maybe I am doing this wrong or there is some other way to achive similiar effect.

I attached file once again with changed names to english .

[Kubson]

Sorry I didnt know about all of this . But in next post and threads I will try to follow rules of this forum .

[Kubson]

How does the second table (C18:F25) relate to the first (C5:F15) ?

You select "BUFOR300" (Column Heading) but how do we/you know which ROW (Bufor1 to Bufor 8) this relates to?

I just make quick draft maybe I do this to quick .

Right now there is Bufor 100 , 200 , 300 , 400 and price to each version below this in sheet pompy C18:F18.

My struggle right now is to link this three fields with drop down list in sheet "kalkulator" to sum prices in "your cost is netto" (kalkulator sheet)
I manage to sum prices only two from three fields with drop down list --> "your cost is netto" by using this Vlookup + match formula .
Now I wanna add one more field(variable) to this as I named "choose option" in "kalkulator" sheet .

Which I attached in second file in my secend post .

[JohnTopley]

Try

in C17

Please Login or Register  to view this content.

[Kubson]

I think is actually what I wanted and is working . Thank you Sir very much !

[Kubson]

If this possible I wanna please admin to not close this topic yet . I may need some advice because I am still working on this calculator .
I will for sure leave msg here to close this topic .

Thank You!

[AliGW]

Nobody will close anything. You will need to mark it as solved.

If you have further questions about your calculator project, you must start a new thread for each query with a suitable title.

So, as this thread is solved, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

[Kubson]

Thank's for explanation I will do like you said above .

[AliGW]

Except you didn't do as I told you - I'll mark this as solved for you.

[Kubson]

Except you didn't do as I told you - I'll mark this as solved for you.

John T. help me that solve my problem in someway , but I am still working on this sheet with vlookup + match , and that why i didn't closed right away after your post .

Sorry maybe I did not understand you correclty .

[AliGW]

In post #9 you said that it was working and was what you wanted, therefore this thread is solved.