Search engine in Excel 2007

[Chintal Gandhi]

Hi...
I have to make excel function or sheet in which i can find particular
data.
For example I have 1 lack data(E.g. Name,Birth Date,Mobile no ....).
And in excel i can enter name,birth data and mobile no and than press
seach button and function will search match data from database(which
in excel only) and display relavent match...

 

[Pete_UK]

You would normally use a VLOOKUP function to do this, and you would
not need a Search button as a spreadsheet would return the matching
data immediately (unlike a database). You can check this out in XL
Help, or if you need further assistance then post some examples of the
data that you have, what columns/cells/sheetnames you use etc.

Hope this helps.

Pete