Need help in small command button Project!!

[tv9_rohith]

I want to do a small project with 2 sheets in the same excel sheet, it can be done using Vlookup in excel but I want to make a document very people can just input the value in the textbox1 and click on command button and related information should display in the 2 textbox which will be pulled from the Sheet2( which will be hidden ).

I have an example below but I have more data than this :

In the First sheet I am planning to place a 2 text boxes and one command button.

1 text box is to input the data

2 Text box is for output

and the command button has to be placed in sheet 1 to rerive data from sheet2 cells.

--

In sheet 2

in 1st column I will give site name's like

Yahoo
Google
Wikipedia
youtube

and in the second column I will the site URL's like

Yahoo.com
Google.com
Wikipedia.com
youtube.com


and when i input data - "Yahoo" in 1 Text Box ( sheet 1 ) and then click on Command button it should retrive me value from sheet2 Column 2.( i.e., Yahoo.com ) and the output should display in 2 Textbox which is there in sheet 1.

Please help me I dont know not getting any idea how to do this..

and kindly note that I will not be able to place combo boxes in this sheet since the lookup data is big.

 

[bensonsearch]

hmm, thats not working for me either.