+ Reply to Thread
Results 1 to 4 of 4

Return value

  1. #1
    Registered User
    Join Date
    04-17-2017
    Location
    Mexico
    MS-Off Ver
    2016
    Posts
    48

    Return value

    yesterday someone of you help me with this,

    What if I want to return the combination (letter and number; A-1, N-2, S-2), next to the result, I painted it in green, of curse it has to change when you select the week number....

    Thank you for your help!
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Return value

    Try this in P2 and fill down until you get blanks. Then copy that range and paste to T2.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  3. #3
    Registered User
    Join Date
    04-17-2017
    Location
    Mexico
    MS-Off Ver
    2016
    Posts
    48

    Re: Return value

    Thank you Dave, it worked perfectly.

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Return value

    Good deal! You are welcome and thank you for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] return FROM TO values from custom defined range , and return all possible combination
    By raj soni in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2016, 01:38 PM
  2. Replies: 2
    Last Post: 05-07-2015, 04:38 PM
  3. Double click row to return data to userform for edit then return back to sheet
    By MattRSJ in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-31-2014, 06:05 AM
  4. Replies: 12
    Last Post: 10-10-2013, 10:02 AM
  5. Replies: 4
    Last Post: 03-13-2013, 12:38 PM
  6. Replies: 6
    Last Post: 10-11-2012, 02:39 PM
  7. Search...Return...give info based on the return address
    By deek1004 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-11-2012, 03:36 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1