Recent content by LINSEY

Dale, Thanks for the offer to help. I'm emailing you my files. Linsey

Can anyone give me a suggestion on where to start with the drop downs?? I have no experience with VB code. Thanks, Linsey

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

Ken, Thanks so much for your help! I was defining my array as the whole column (including field name). When I changed it to just the info, it worked!! linsey

Ken, When I do the CTRL+SHIFT+ENTER I get the curly braces but it gives me "#NUM!" now!! linsey

Ken, I've been trying that formula over and over. It gives me "#VALUE!" every time. There is only one possible match. I can't figure out what's wrong. Can you help??? linsey

Thanks for the reply Geoff. I'm trying to avoid concatenating, because it may cause other issues if I add a column to my current database. Does anyone have another suggestion??? linsey

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

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

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

I think I figured it out by myself... Cell A1 Defined as "STYLEINPUT" Cell A2 Defined as "VERSIONINPUT" Formula in H2 should be: AND(STYLE=STYLEINPUT,VERSION=VERSIONINPUT) It's working for me now. Thanks for talking me through this guys!!! Linsey

Skip, I have defined my database as STYLE in the workbook where I am writing the formula. I have also defined two cells as my criteria named CRIT. Here's a little more detail: DATABASE: "STYLE" STYLE[tab][tab]VERSION[tab][tab]DESCRIPTION LYW029[tab][tab]001[tab][tab][tab]12 oz. RHT...

Dale, I'm sending you an email with my database and sample worksheet attached. Thanks so much for trying to help me! Linsey

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

it is open, but i would like for the function to work even if it is not.