Search and Find box

[Belter]

Hi guys

I would like to create a database in excel where i can create a database on sheet 2 and have a multiple search box on sheet one, is this possible.

[darkyam]

I think you'll have to be a bit more specific. It sounds like you are trying to type in a value on sheet 1 and have it return info from sheet 2. If that's correct, try =VLOOKUP(A1,Sheet2!A1:B100,2,False) where A1 is the value to be looked up, the second argument is the range, the third is the column to return, and False means lookup the exact match of A1 instead of the closest match without going over.

[Belter]

I think you'll have to be a bit more specific. It sounds like you are trying to type in a value on sheet 1 and have it return info from sheet 2. If that's correct, try =VLOOKUP(A1,Sheet2!A1:B100,2,False) where A1 is the value to be looked up, the second argument is the range, the third is the column to return, and False means lookup the exact match of A1 instead of the closest match without going over.

That's right, but what I would like to do is have a multiple search box on sheet 1

For e.g

say I want to search a name and address or name and post code etc..

and I would also like sheet 2 protected so it it can't be altered/changed by anyone else but me.