+ Reply to Thread
Results 1 to 8 of 8

Vlookups with multiple choices?!?!

  1. #1
    Registered User
    Join Date
    02-23-2010
    Location
    Brighton, England
    MS-Off Ver
    Excel 2007
    Posts
    32

    Vlookups with multiple choices?!?!

    Hi All,

    I have (with your help) created a series of 3 dropdowns columns that poulate their data depending on what is in the lead column.

    However this has confused my vlookup. When the user picks the lead column (in our spreadsheet this is country) the drop downs show all the customers, suppliers and products in the dropdowns.

    But for our OLE to work i had a VLookup column looking at the customer name and populating the code (this has to be a in seperate column)
    Now i have 3 different sets of data in the dropdowns. However in some of our entities we have the same customer name with a different code in the different entity. The lookup has to pick the right code or the OLE will fail.

    Can i have a Vlookup that checks which data to check through. ie
    =Vlookup($A$4 (this being the bit it has to identify to pick which list to look at) and then the rest of the function?

    I hope this makes sense it is a bit rambling

    Thanks in advance!!
    Last edited by Emmaly; 11-08-2011 at 09:35 AM.

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Vlookups with multiple choices?!?!

    Ηι

    Be sure attaching a sample of your work and showing what exactly is your goal, you will find much more easily your solution.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    02-23-2010
    Location
    Brighton, England
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: Vlookups with multiple choices?!?!

    Here is the example i was using for my drop downs with the extra bit in.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    02-23-2010
    Location
    Brighton, England
    MS-Off Ver
    Excel 2007
    Posts
    32

    Exclamation Re: Vlookups with multiple choices?!?!

    Can anyone out there help me? I have to present my spreadsheet to the Directors this afternoon so if this isn't possible i need to find a way around it.

  5. #5
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Vlookups with multiple choices?!?!

    Hi

    I think that your sample is not understood. At least to me.
    In columns B, C, D, write:
    I have got this bit to work but now i need the code
    How did you get this information does not appear anywhere.
    As far as I understand Customer code, depends on the other 3 columns that does not seem to identify themselves.

    As a hurry, I send you a quick proposal (without getting the data I want), do help make your job.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    02-23-2010
    Location
    Brighton, England
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: Vlookups with multiple choices?!?!

    Hi,

    Here is the attachment with the dropdowns working. These are working fine, but what i need is depending on what is chosen in column A i need the lookup to see which country it is, then look at the information in column B and then match the name with the code in Sheet1.

    As we can have the same customer, with the same name in more than one country the lookup needs to take into account the country from where it is picking the code. Otherwise the code will be wrong and the OLE i have linked to it won't work.

    Does this make more sense?
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    02-23-2010
    Location
    Brighton, England
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: Vlookups with multiple choices?!?!

    Hi All,

    This still isn't solved. Does anyone have any ideas on how to do this or is it not possible? Thanks

  8. #8
    Registered User
    Join Date
    02-23-2010
    Location
    Brighton, England
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: Vlookups with multiple choices?!?!

    Hurrah, solved. I worked it out myself. An IF statement with VLookups inside it for each variable!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1