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 ]
Office Time Address
(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
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 ]
Office Time Address
(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
