how to put the result from a dropdown in the worksheet

[lui de sagun]

It's me again, my problem is just a continuation of my previous post
(fill combobox with values from a row of another worksheet). Now that kchiba already solved my first concern, my next problem is how can I be able to extract the corresponding cost from "Discounted Cost" column (can be seen in the ServiceDesk column) based value that I will choose from the dropdown (cmbTickets) and put it in the "view" sheet? Can you help me with this again?

 

[kchiba]

Where do you want to put the discounted cost, you can use a VLOOKUP for this

kanti

 

[lui de sagun]

Where do you want to put the discounted cost, you can use a VLOOKUP for this

kanti

Hi Kanti,

Apologies for the late reply. Can this be placed on column Q row 13 in the "view" sheet and it will only become visible after I clicked the "show data" button? I initially thought of the VLOOKUP but am not sure if that can be possible if that will be placed there.

 

[kchiba]

Hi Lui,

The attached file has a VLookup formula in Q13, before you can do that you need to link the ComboBox to a cell and this is shown in the GIF file.

 

[lui de sagun]

Awesome! thanks again! you're an angel

 

[kchiba]

you're welcome