+ Reply to Thread
Results 1 to 3 of 3

formula that return to next column

  1. 02-12-2017, 11:13 AM #1
    xymcrush17
    xymcrush17 is offline
    Registered User
    Join Date
    02-26-2015
    Location
    Jakarta, Indonesia
    MS-Off Ver
    2007
    Posts
    33

    Red face formula that return to next column

    hi expert

    sorry for unclear title

    here for example

    column I6=sheet1!H12

    i want this expected value below but with formula

    M6=sheet1!H13
    Q6=sheet1!H14
    U6=sheet1!H15
    Y6=sheet1!H16
    AC6=sheet1!H17
    AG6=sheet1!H18
    AK6=sheet1!H19
    Reply With QuoteRegister To Reply
  2. 02-12-2017, 11:25 AM #2
    canapone
    canapone is offline
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: formula that return to next column

    Hi,

    in M6

    Please Login or Register  to view this content.

    to be copied in Q6-U6...

    Regards
    Attached Files Attached Files
    Last edited by canapone; 02-12-2017 at 11:29 AM.
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.
    Reply With QuoteRegister To Reply
  3. 02-12-2017, 06:04 PM #3
    Amanda Wilso
    Amanda Wilso is offline
    Forum Contributor
    Join Date
    12-18-2016
    Location
    London
    MS-Off Ver
    Microsoft 2013
    Posts
    145

    Re: formula that return to next column

    Since this is a formula problem, might be easier if If you upload your sheet to google sheets and use the add-ons feature and add Formula Helper. I'm using it myself. It looks for complicated formulas and helps you solve it.. Regarding your question I'll be able to get to it in 10 minutes.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Need formula to return column letter
    By NS4Excel in forum Excel Formulas & Functions
    Replies: 26
    Last Post: 03-18-2016, 10:01 AM
  2. Formula to return text that corresponds to a MAX formula done in a different column
    By rjw524 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-17-2015, 03:33 AM
  3. Formula to return column header
    By smselvi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-07-2014, 05:56 AM
  4. how do I write this formula? If column B contains column A value, return value in column C
    By movinghome in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-16-2014, 12:17 AM
  5. formula to return value of column has text
    By n1kk1 in forum Excel General
    Replies: 3
    Last Post: 12-10-2012, 05:18 PM
  6. Formula to find all matches in column A and return cells from column C
    By GenericPat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-19-2012, 04:56 PM
  7. [SOLVED] Simple formula to match column A, sheet1, with column A, sheet2, return text answer
    By Connie5761 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-14-2012, 02:56 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