# Help, Search Box Query

#### Jay_S1

##### New Member
Hi,

This is probably a basic question but im hoping someone can save me time and explain the best/simplest way to create a search box? Ive been trying to use VBA, with limited knowledge/success, but i was hoping there's a simple standard function that can also work.

Here's the breakdown of what Im trying to do:

Ive one datasheet (Sheet_1) with a list of postcodes in column A and 3 further columns of data in B,C & D. What im looking for is a way to create a search box a another sheet (Sheet_2) where you can type in a postcode which will then bring up the corresponding info in the opposite 3 columns.

This is what I have :

Sheet_2 :

Search [ cell:C3 ]

(cell:D10) (cell:E10) (cell:F10)

Ive created a vlookup that works but it doesn't automatically change when I add a new post code to the search box (cell c3) - I need to go into each of the 3 result boxes (Office, time & address) and double click to get the formula to recalculate the new search request.

The data sheet (Sheet_1) is in a table form ranging from A2 to F6422

With th 3 vlookups being :

=VLOOKUP(C3,Sheet_1!\$A\$2:\$B\$6422,2) - Office box

=VLOOKUP(C3,Sheet_1!\$A\$2:\$C\$6422,3) - Time box

=VLOOKUP(C3,Sheet_1!\$A\$2:\$D\$6422,4) - Address Box

With my limited knowledge i dont know if im not using the correct function (vlookup) or whether I missing an extra command or detail to switch it on.

Any help would be greatly appreciated as it would know doubt save me a large amount of time/bumbling.

Thanks

Jay

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Replies
13
Views
349
Replies
5
Views
459
Replies
1
Views
130
Replies
3
Views
190
Replies
2
Views
406

1,127,099
Messages
5,622,698
Members
415,922
Latest member
gemmatay88

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back