concatenate,vlookup functions, and arrays

  • concatenate,vlookup functions, and arrays 3

    1. no (2) 67%
    2. yes (1) 33%

    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