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 TouchToneTommy 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: *

  • Users: LINSEY
  • Content: Threads
  • Order by date
  1. LINSEY

    Excel 2000: Combo/Drop Down Box linked to another Workbook

    I'm trying to create a form in an excel spreadsheet where you can select a "style" from a drop down menu and based on the selection populate additional cells. The "style" list would come from a database ("Fabsheet Database") in another excel workbook. Here's the basic layout of "Fabsheet...
  2. LINSEY

    Excel 2000: How to "Lookup" Based on Criteria from 2 Columns

    I'm having trouble looking up information from a database based on criteria from 2 columns. Here's the basic layout of the database: STYLE[tab][tab]VERSION[tab][tab]A/I[tab][tab]TRIAL LYW[tab][tab][tab]000[tab][tab][tab][tab]I[tab][tab][tab]T111...
  3. LINSEY

    Excel 2000: Nested IF functions - I need to nest more than 7!

    How can I get this formula to work if Excel will only let me use 7 nested functions...
  4. LINSEY

    Excel 2000: Need Macro to Print Form for Each Selected Record

    I have a spreadsheet with records sorted by Style & Version: STYLE[tab][tab]VERSION[tab][tab]COLOR[tab][tab]WEIGHT LYW029[tab][tab]000[tab][tab][tab]Carbon[tab][tab][tab]12.0 LYW029[tab][tab]001[tab][tab][tab]Carbon[tab][tab][tab]11.5 LYW029[tab][tab]002[tab][tab][tab]Carbon[tab][tab][tab]11.0...
  5. LINSEY

    Excel 2000: Using DGET function when database is in another workbook.

    I posted this question yesterday, so i'm sorry for reposting but I really need help. I want to use the DGET function to extract information from a database that is in a different workbook. DATABASE WORKBOOK (defined in new workbook as "STYLE"): STYLE DESCRIPTION LYW029...
  6. LINSEY

    Excel 2000: Using DGET function when database is in another workbook

    I want to use the DGET function to extract information from a database that is in a different workbook. I tried defining the database in my new workbook but I'm not sure how to write the formula correctly. DATABASE WORKBOOK (defined in new workbook as "STYLE")...
  7. LINSEY

    Excel 2000: Conditional Formatting when DGET Function returns #VALUE!

    I have set up a form that uses DGET functions to pull data from a spreadsheet. If the cell on the spreadsheet does not contain data, the DGET function returns "#VALUE!". I would like to use conditional formatting to change the font color to white on cells that contain...
  8. LINSEY

    Excel 2000: (&) Operator in VLOOKUP will not work

    My main spreadsheet(STYLE) has a style column, version column, styleversion column, and many data columns that follow: STYLE[tab]VERSION[tab]STYLEVERSION[tab]DATA[tab]DATA[tab]DATA[tab] The STYLEVERSION column uses an (&)operator to combine style and version columns. On a separate sheet, I...
  9. LINSEY

    Excel 2000: Lookup Formula Returns #N/A

    Here's the layout of my spreadsheet: STYLE[tab][tab]FINISH[tab]SATURATOR LYW329[tab][tab]3[tab][tab][tab]FERN PRM685[tab][tab]6[tab][tab][tab]BLACK KXWJ95[tab][tab]J[tab][tab][tab]YELLOW NOM319[tab][tab]3[tab][tab][tab]FERN Formula for "FINISH" column is: MID(STYLE,4,1) Formula for...
  10. LINSEY

    Excel 2000: How can I use 2 fields to lookup info in another field?

    Here's the (very) basic layout of my spreadsheet: STYLE[tab]VERSION[tab]YARN TYPE LYW[tab][tab]001[tab][tab][tab]1000 LYW[tab][tab]002[tab][tab][tab]1050 LYW[tab][tab]003[tab][tab][tab]4001 PRM[tab][tab]001[tab][tab][tab]2001 PRM[tab][tab]002[tab][tab][tab]1002...

Part and Inventory Search

Back
Top