How Do I Match Excel Entries to Company Online Database?

[bencar]

I got an excel sheet with 150,000 records. I need to match up each record with what we have on file in our online database. My job is to match the first 6 words in a cell to data in this online database. My job requires that I match each product in our inventory (in the spreadsheet) to products we have listed online. Doing this one by one takes forever, of course. How can I match the products in the spreadsheet to the products in our onine database rapidly without doing so one item at a time which takes forever??

 

[easy2understandexcel]

Can you give a little sample data?

 

[bencar]

Can you give a little sample data?

Sure...

Say the cell in the sheet that I want to look up in our company database starts with: "panama 230 call log 33 code bluestar river". I want to match only the first 5 words of this cell to our online database. Again there are 150,000 entries and I need to match up thousands at once, not one at a time.

Please let me know. Thanks !!!!!!!!!!!

 

[easy2understandexcel]

you can use a wildcard "*".

For example if "panama 230 call log 33 code bluestar river" is in cell A1, and your database is in cells B1:B150000.

=vlookup(A1&"*", $B$1:$B$150000, 1, false)

 

[bencar]

ADVERTISEMENT

you can use a wildcard "*".

For example if "panama 230 call log 33 code bluestar river" is in cell A1, and your database is in cells B1:B150000.

=vlookup(A1&"*", $B$1:$B$150000, 1, false)

You dont understand what I'm trying to say. I need to look up entries in our excel spreadsheet in our ONLINE DATABASE, not on an excel spreadsheet. What I want to know is how to look up the entries from our spreadsheet which contains 150,000 records and match them to those in our ONLINE DATABASE. But I want to know how to look these entries up by the hundreads, not one by one which takes forever.

 

[seekerarcane]

You have options here,

First, use plsql and query down the data from your online database in Excel Format (dont know which database you are using), and match those data with your spreadsheet data set, using Vlookup function as described above

Sencond, consult any relevant database developer to match your spreadsheet data set with online database. People here on this forum would give you Excel related solutions and formulas of your problem, not related to databases.

Thanks

 

[Divya Manoharan]

ADVERTISEMENT

Hi !

=if(And(c11<time(18,0,0),c11>time(9,0,0))," accept ","not accept")
please let me know the mistake
the time should be accepted only when the time is greater than 9 am and less than 6Pm

 

[bencar]

Hi !

=if(And(c11<time(18,0,0),c11>time(9,0,0))," accept ","not accept")
please let me know the mistake
the time should be accepted only when the time is greater than 9 am and less than 6Pm

What are you talking about??
</time(18,0,0),c11>

 

[bencar]

You have options here,

First, use plsql and query down the data from your online database in Excel Format (dont know which database you are using), and match those data with your spreadsheet data set, using Vlookup function as described above

Sencond, consult any relevant database developer to match your spreadsheet data set with online database. People here on this forum would give you Excel related solutions and formulas of your problem, not related to databases.

I see.. I'll dive deeper into plsql. I bet only a database dev would know how this works. Do you suggest any DB dev forums out there cthat may help me?

Btw, would you know ho to use plsql to query the online DB into excel?