Recent content by Darzza

Geoff/bluedragon2, Not for the first time today you have saved my bacon! Many thanks. P T Darzza 'Try fail, try again fail better....'

Hi Ok on sheet 2 there are 31 columns (AE) I need the information from column 5 (E) from this sheet. I would also like it to display the information it looked up too (i.e. the part numbe from column 1 (A). I would like the information to be displayed in columns 8 and 9 of sheet 1. Thanks...

Hi Ok new formulae =VLOOKUP(A3,Sheet2!A2:A33148,6,0) Now the output I get is #REF! Any ideas? oh the pain.... Cheers. P T Darzza 'Try fail, try again fail better....'

Hello again, I have tried to make this formulae work. To make life easier (or so I thought) I copied both of my sheets into a new workbook (so I am now working from one Workbook with two sheets in it) The formulae I have is:- =VLOOKUP(A3,Sheet2!A2:A33148+Sheet1!A2:A33148,5,0) I have put this...

Thanks for your help. Will this work even when the spreadsheets are separate? Is there any chance you could explain what each parts of the formulae mean? Just so I know how to correspond it to my own spreadsheets. Thanks once again. P T Darzza 'Try fail, try again fail better....'

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

Thanks very much! P T Darzza 'Try fail, try again fail better....'

HI Geoff, There is no unique ID. Column 'A' list the parent item, for example for part number 1234. Column 'A' would have 20 rows of 1234 (Cells 'A1 to A20') and column 'B' would have different part numbers for these cells. It is not important that I keep all of the column 'B' part numbers...

Hi, I have a huge excel spreadsheet (0ver 20000 rows, and 15 columns) The spreadsheet contains a lot of information on part numbers, however it also lists all the component parts to particular parent part numbers. Is it possible to filter/delete rows of information (short of highlighting it...

Thanks very much John. I just hope that we can sort the problem when we convert all of our PM files to InDesign CS2. P T Darzza 'Try fail, try again fail better....'

Hello, I am trying to export a Polish PM file to PDF - however when I do this it tells me that Fonts - Times New Roman CE - Arial CE Ok - seems simple enough - just install these fonts to my comfuser and away I go... but no - it is still not working! Any Ideas??? Also, we are going to be...

HI Michael, So to sort out this mess - do I just need to get the user to join back to the default workgroup? Thanks, P T Darzza 'Try fail, try again fail better....'

HI, So a few weeks ago I set up a database with a new workgroup information file (this is at work, and I put the workgroup info file on the network). Now it appears we have a few problems: 1) For most but not all other databases (not set up be me) the users need access to, they need to use...

Hello, I am trying to export a Polish PM file to PDF - however when I do this it tells me that Fonts - Times New Roman CE - Arial CE Ok - seems simple enough - just install these fonts to my comfuser and away I go... but no - it is still not working! Any Ideas??? Also, we are going to be...

Hello Mike!! P T Darzza 'Try fail, try again fail better....'