Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Darzza

    LOOKUP table query. Please help.

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

    LOOKUP table query. Please help.

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

    LOOKUP table query. Please help.

    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....'
  4. Darzza

    LOOKUP table query. Please help.

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

    LOOKUP table query. Please help.

    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....'
  6. Darzza

    LOOKUP table query. Please help.

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

    Excel - Remove duplicate cells - Please help.

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

    Excel - Remove duplicate cells - Please help.

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

    Excel - Remove duplicate cells - Please help.

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

    Fonts Not available

    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....'
  11. Darzza

    Fonts Not available

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

    Major Security Problem - please help.

    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....'
  13. Darzza

    Major Security Problem - please help.

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

    Fonts not Available

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

    database development help!! :-)

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

    Printed ID book - but missing elements in .pdf

    Does any1 in here know the answer? Please........... I've ran out of things to try. P T Darzza 'Try fail, try again fail better....'
  17. Darzza

    TOC problems after InDesign to .PDF

    Does any1 know the answer? Please........... P T Darzza 'Try fail, try again fail better....'
  18. Darzza

    TOC problems after InDesign to .PDF

    Hello, Ok - thanks for the advice on how to print a number of documents all together as a book to pdf. Now I have done this - I am experiencing some problems:- On the TOC (I have a TOC defined for each section) I want to be able to click on the individual subsections and be taken straight to...
  19. Darzza

    Printed ID book - but missing elements in .pdf

    Hello, Ok - thanks for the advice on how to print a number of documents all together as a book to pdf. Now I have done this - I am experiencing some problems:- On the TOC (I have a TOC defined for each section) I want to be able to click on the individual subsections and be taken straight to...
  20. Darzza

    Why pictures so fuzzy?

    Thanks very much for your help people. P T Darzza 'Try fail, try again fail better....'

Part and Inventory Search

Back
Top