Results 1 to 26 of 26

Non Adjacent Multiple Columns

Threaded View

  1. 09-06-2022, 05:00 AM #1
    paradise2sr
    paradise2sr is offline
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2024
    Posts
    1,384

    Non Adjacent Multiple Columns

    Hi,


    How can I get the non adjacent multiple columns in 'Result' worksheet at column G,H,I,J,K by matching column A with that of B column of 'Data' Sheet and pull data B,E,K,Q,R in a single formula.It should be versatile so that it can be used in some other kind of data set having different scenario.
    Attached Files Attached Files
    Last edited by paradise2sr; 09-06-2022 at 05:10 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] deleting multiple non adjacent columns
    By bsesender in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-13-2018, 04:23 AM
  2. Multiple lookup with non-adjacent columns
    By ghg in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-17-2015, 02:39 PM
  3. Look up a value from multiple columns and return an adjacent value
    By abaginska09 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-07-2013, 04:21 PM
  4. Need help with combining multiple non-adjacent columns
    By ngpm515 in forum Excel General
    Replies: 0
    Last Post: 11-17-2011, 04:18 PM
  5. Copy formulas to adjacent columns - multiple cells and multiple sheets
    By swanseaexcel in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-12-2011, 06:21 AM
  6. Looking through multiple columns, getting adjacent value
    By rockville9 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2010, 04:11 PM
  7. Copying multiple columns not adjacent
    By Doug Wilson in forum Excel General
    Replies: 2
    Last Post: 07-08-2005, 04:05 PM

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1