Multiple VLookup+return result in combobox

[egl]

Hi,
I am stuck for the following task. I really cannot figure out how to fix it. I'll be very very appreciate if you could give me some direction. Following is what I am trying to achieve:
User input a material at Result!A3 and the combo box should retrieve the list of material+cost refer to the input data.

I plan to use the multiple vlookup function to search the material from the material data list (Data!A6:F9) and the result from material data should map/refer to the cost data (Data!A19:B33). Finally, the list of material+cost should be retrieved in the combo box.

Thanks in advance for your help!
Eugene

[trucker10]

something like this? 2 different > validation cell > and a combobox .

look also ( press key ) Ctrl F3 .

[egl]

Thanks for your reply Trucker10. The task has not been fully resolved...You gave good idea though

The combobox should reflects on the material input data at Result!A3 (ie. if I type Concrete in A3, the combo box should shows only C1, C2, C3 instead of the full price list)

[trucker10]

Columncount cbobox 2 ,now you see column A and B

[egl]

Thanks Trucker10! Sorted!