Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



View Poll Results: does this formula give you new ideas?

Voters
3. You may not vote on this poll
  • yes

    1 33.33%
  • no

    2 66.67%
Results 1 to 8 of 8

Thread: concatenate,vlookup functions, and arrays

  1. #1
    Join Date
    12th July 2006
    Location
    atlanta
    Posts
    8

    concatenate,vlookup functions, and arrays

    OK people I have a problem.
    A novice I am. I'm sure this is simple enough for most of you guys. Most of it has been comleted except one last part. I have drop down fields using a vlookup to grab the corresponding data in a colums next it which is being concatenated into a one big cell. The problem is a set of other columns that I need to pull data from but its dependant to a previous column. In the attachment you see which ever region is selected the following column data is grabbed and the same goe for title. Now when the location is selected the info in its column should be selected that corresponds to the row that the specific title is on. example
    if selected: North America>Secretary>Texas
    results: A Crazy Mix->;typical,Notepad, pen,square dance
    I am sure you guys can figure this out.
    Thanks
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    26th July 2004
    Posts
    1,373

    Re: concatenate,vlookup functions, and arrays

    use this formula

    =CONCATENATE($B$10," ",INDEX($E$5:$E$7,MATCH(A13,$D$5:$D$7,0)),INDEX($G$5:$G$7,MATCH(B13,$F$5:$F$7,0)),",",OFFSET($G$4,MATCH(B13,$F$5:$F$7,0),MATCH(C13,$H$4:$K$4,0)))

    see the attached file
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    17th October 2005
    Location
    Brisbane Australia
    Posts
    553

    Re: concatenate,vlookup functions, and arrays

    yes

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,718

  5. #5
    Join Date
    12th July 2006
    Location
    atlanta
    Posts
    8

    Re: concatenate,vlookup functions, and arrays

    You guys are awesome! I would have never figured that out!
    Thanks Thanks Thanks

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    12th July 2006
    Location
    atlanta
    Posts
    8

    Re: concatenate,vlookup functions, and arrays

    I really did not mean to do a poll i just click on the box by mistake

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    28th January 2003
    Location
    Solihull - England
    Posts
    8,678

    Re: concatenate,vlookup functions, and arrays

    Lol...
    Kind Regards, Will Riley

    Web Presence:
    LinkedIn: Will Riley

  8. #8
    Join Date
    17th October 2005
    Location
    Brisbane Australia
    Posts
    553

    Re: concatenate,vlookup functions, and arrays

    very even at the moment

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Vlookup And Multiple Arrays
    By BrianNC in forum EXCEL HELP
    Replies: 6
    Last Post: February 6th, 2007, 15:02
  2. VLOOKUP on arrays
    By ghh3rd in forum EXCEL HELP
    Replies: 7
    Last Post: May 25th, 2006, 05:03
  3. Replies: 3
    Last Post: March 2nd, 2005, 22:28
  4. passing arrays to functions
    By p_e_t_e_r in forum EXCEL HELP
    Replies: 3
    Last Post: August 9th, 2004, 02:31

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
  •  
porno