Results 1 to 10 of 15

Thread: Best way to cross populate multiple arrays based on data entry into a single array?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 01-23-2013, 05:22 AM #3
    mrmmickle1
    mrmmickle1 is offline
    Member mrmmickle1's Avatar
    Join Date
    Sep 2012
    Posts
    51
    Rep Power
    14

    I think I was trying to make it too complicated

    Is this similar to what you wanted?

    Try This in D3:

    =IF(ISNUMBER(SEARCH("*Tinker*",D24)),$B$24, IF(ISNUMBER(SEARCH("*Tinker*", D26)), $B$26, IF(ISNUMBER(SEARCH("*Tinker*", D28)), $B$28, IF(ISNUMBER(SEARCH("*Tinker*", D30)), $B$30, IF(ISNUMBER(SEARCH("*Tinker*", D32)), $B$32, "No Trainer Available")))))

    Change Tinker to Tailor for D5.... I have attached an example for reference
    Attached Files Attached Files
    Last edited by mrmmickle1; 01-23-2013 at 05:35 AM.
    Using Excel 2010
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Consolidate Import Data From Same Sheet In Multiple Workbooks In To Single Workbook
    By Jorrg1 in forum Excel Help
    Replies: 1
    Last Post: 05-09-2013, 08:56 AM
  2. Lookup Populate Grouped Information Based On DropDown Selection
    By rich_cirillo in forum Excel Help
    Replies: 2
    Last Post: 04-10-2013, 12:40 AM
  3. Lookup Data From Multiple Sheets To Single Sheet Consolidated View Using Formula
    By Redwhite in forum Excel Help
    Replies: 2
    Last Post: 03-21-2013, 10:38 PM
  4. Converge Data From Multiple Columns To Single Column
    By ayazgreat in forum Excel Help
    Replies: 3
    Last Post: 12-14-2012, 10:55 PM
  5. clearing contents of array of ranges using a single line of code
    By Junoon in forum Excel Help
    Replies: 4
    Last Post: 05-14-2012, 11:58 AM

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
  •  

Forum Rules