Search and Finding between 2 workbooks

I have a large database that contains information layed out as follows:

(column G)

CallDirect_CDR-790seu_approval.doc
CallDirect_CDR-790seu_approval.pdf
CallDirect_CDR-790seu_approval_A.doc
Motorola_V975.doc
Motorola_V9x.html
Motorola_V9x.pdf

etc... (it has 4000 lines)

I need a program or function to search through each entity and pick up the brand (the words before the underscore.

so for example if we take the RED example, it should pick up just the following:

CallDirect

Then I need it to find the model, in the same example it should find the following:

CDR-790seu

So now it has gained 2 vales; the name: CallDirect and the model:CDR-790seu .

The next stage is for it to look through a different workbook (this workbook only contains 1 sheet) - (I can arrange this sheet to be put in the same workbook as the the first database) and firstly search the name, then product... the 2.d database it needs to look through wout look like this:

(all *'s indicate a new column)

A1 * A2 * A3 * A4 * A5

114 * closed * Call Direct * router * CDR-790
153 * closed * Calyptech * FWT * iFWT
35 * closed * Calyptech * FWT * iFWT

It would find the red row and take just what value is in A1, in this case 114.

This 114 value would now be placed back in the original sheet next to the line it was searching from to now make:

CallDirect_CDR-790seu_approval.doc * 114


If anyone could help me with this that would be amazing...

thanks guys

benjaminpott