Go Back   Home > Forums > Member Areas > The Lounge

The Lounge A place to talk about almost anything but politics and religion.

Please consider donating to help us continue to serve you.

Ads on/off / Custom Title / More PMs / More album space / Advanced printing & mass image saving
Reply
 
Thread Tools Search this Thread
Old 4th August 2005, 04:41 AM   #1
Stocker is offline Stocker  United States
diyAudio Member
 
Join Date: Dec 2003
Location: Austin
Default Tricky MS Excel function

I am trying to do something for work that is beyond me (for now)
I have a drop-down list for each digit in a model number that will pull out the position-specific subassembly part number and description in another area on the page. You select A from the first position and it pops out a PN and description for a flange, etc. for six positions in a model number.

The last two positions are together and have anywhere from 4 to 6 parts bound up in them. How can I have a single drop-down item call out a range of fields or a list of several different lines on a list of parts?

This is stumping me.

Any ideas?
__________________
Jesus loves you.
  Reply With Quote
Old 4th August 2005, 11:32 PM   #2
Stocker is offline Stocker  United States
diyAudio Member
 
Join Date: Dec 2003
Location: Austin
Talking I Got It!

Thank God! Thank my coworkers too.

= IF(C9=G33,Parts3!B24,(IF(C9=G34,Parts3!B29,(IF(C9= G35,Parts3!B34,(IF(C9=G36,Parts3!B39,"INVALID")))) )))

Say that 5 times, fast.
__________________
Jesus loves you.
  Reply With Quote
Old 5th August 2005, 04:57 AM   #3
Wizard of Kelts
diyAudio Moderator
 
Join Date: Sep 2001
Location: Connecticut, The Nutmeg State
Stocker:

I am completely self taught on the computer.

I have found invaluable assistance for using Excel, (albeit I use it for simpler problems than your own), at www.aumha.net.

It is a computer help forum, and the helpful atmosphere is very similar to diyAudio.

If you have a future problem, I suggest you give them a try. They are very good and courteous.
__________________
"A friend will help you move. A really good friend will help you move a body."
-Anonymous
  Reply With Quote
Old 6th August 2005, 03:37 AM   #4
Stocker is offline Stocker  United States
diyAudio Member
 
Join Date: Dec 2003
Location: Austin
I'm headed there right now, and thanks for the tip!

I realized today that the above is not good enough For easy expansion in the future; I resorted to further sorting and simple VLOOKUPS for the fields involved.

The current problem: I need to return a value based on two other cells. It has to be expandable as simply as a VLOOKUP. I know this can be done but I am having trouble
__________________
Jesus loves you.
  Reply With Quote
Old 7th August 2005, 04:29 AM   #5
Wizard of Kelts
diyAudio Moderator
 
Join Date: Sep 2001
Location: Connecticut, The Nutmeg State
Well, if Aumha does not work, (your problem is extremely involved}, there are always Google groups.

Just go to Google.com, click on groups, then put Excel in the Search box. I tried it, and I got several places to go where they seem to be into Excel programming specifically. Here is one-there were several others.

Be sure to tell them which version of Excel you have-these guys look pretty advanced and likely to assume you have the latest if you don't tell them.

Let us know how you make out on this.
__________________
"A friend will help you move. A really good friend will help you move a body."
-Anonymous
  Reply With Quote
Old 9th August 2005, 03:55 AM   #6
Stocker is offline Stocker  United States
diyAudio Member
 
Join Date: Dec 2003
Location: Austin
My boss must have been disappointed I didn't come up with it sooner. One of the brothers from church got as far as "you could CONCATENATE..." and I was done with the project. Concatenate the results, VLOOKUP compare it to the lists, bang. Thanks.
__________________
Jesus loves you.
  Reply With Quote

Reply


Hide this!Advertise here!
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tricky CA21REX question Daze Full Range 0 7th March 2008 07:16 PM
Tricky op-amp based VR problem matejS Power Supplies 22 29th August 2007 03:27 AM
A tricky question from a novice msharpe Multi-Way 14 28th May 2006 06:41 AM
Tricky little problem with Z4 component Buhl Pass Labs 5 21st August 2003 03:10 PM


New To Site? Need Help?

All times are GMT. The time now is 08:03 AM.


vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd.
Copyright 1999-2014 diyAudio

Content Relevant URLs by vBSEO 3.3.2