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-24-2013, 04:44 AM #8
    mrmmickle1
    mrmmickle1 is offline
    Member mrmmickle1's Avatar
    Join Date
    Sep 2012
    Posts
    51
    Rep Power
    14
    Put this in D6 and autofill the formula to the right.

    =IF(ISNUMBER(SEARCH("*Tailor*",D24)),D25, IF(ISNUMBER(SEARCH("*Tailor*", D26)), D27, IF(ISNUMBER(SEARCH("*Tailor*", D28)), D29, IF(ISNUMBER(SEARCH("*Tailor*", D30)), D31, IF(ISNUMBER(SEARCH("*Tailor*", D32)), D33, "No Trainer Available")))))

    I have attached an example.
    Attached Files Attached Files
    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