Hi,
I have 2 database:-
Spreadsheet (1) Is a list of part numbers ('A1' to 'A6000')
Spreadsheet (2) Is a complete list of all the different part numbers we offer (about 35000)
What I need to do is to look-up part numbers in spreadsheet (1) in spreadsheet (2). However I not only need to know that the part numbers are in spreadsheet (2) but I also need to take some other corresponding information from this spreadsheet.
Is it possible to do this automatically i.e. Look up all spreadsheet (1) part numbers in column A of spreadsheet (2) and generate the results (including columns 'e' and 'g') into a new spreadsheet.
Wow - I hope all that makes sense... cause you are a better man/woman than I if it does!
If you need any further information, please let me know.
Thanks very much for all your help,
P
T
Darzza
'Try fail, try again fail better....'
I have 2 database:-
Spreadsheet (1) Is a list of part numbers ('A1' to 'A6000')
Spreadsheet (2) Is a complete list of all the different part numbers we offer (about 35000)
What I need to do is to look-up part numbers in spreadsheet (1) in spreadsheet (2). However I not only need to know that the part numbers are in spreadsheet (2) but I also need to take some other corresponding information from this spreadsheet.
Is it possible to do this automatically i.e. Look up all spreadsheet (1) part numbers in column A of spreadsheet (2) and generate the results (including columns 'e' and 'g') into a new spreadsheet.
Wow - I hope all that makes sense... cause you are a better man/woman than I if it does!
If you need any further information, please let me know.
Thanks very much for all your help,
P
T
Darzza
'Try fail, try again fail better....'