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
 
Back
Top