Search engine in Excel 2007

  • Thread starter Thread starter Chintal Gandhi
  • Start date Start date
C

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...
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
how to create an excel vba phone book? 5
Imbedded Data Input sheet 3
Searching a table of data using an array and returning the array's header?!? 4
Excel Send emails based on Dates in an EXCEL sheet. 0
Access Access, problem with query. 5
Comparing two worksheets and highlight unmatched Data 0
Calculating age from date of birth and ignoring if blank 5

Back
Top