populate worksheet cell based on two dimensional lookup values of combobox

i want to save textbox1 value based on combobox and textbox value as on user form

for example in column B there are product name and in first row there is date. now in combobox1 we select "prod2" and date is 27-12-2014 then textbox1 value should goto respective cell (D3).

data sheet is attached here.

please help...please ....its urgent required

I adapted your file & code to meet your needs. See attachment

I recommend change TextBox3 to ComboBox or ListBox to select though...

Please Login or Register  to view this content.

for mehmetcik

first check Sheet properly... commandbutton works as good as it should be on my PC.

i tried many codes that worked with numeric values but not with date values so i post problem on forum, and i did not attached my code so it do not create any confusion with viewers,...I think finding mistakes is more difficult then making new code.

checks my other post , already marked as solved whenever I found solution. and I know the rules of forum.

thanks

thank you so much for your help..jindon , Zekraoui

I got what i wanted.