+ Reply to Thread
Results 1 to 2 of 2

Return last value from a row on another tab

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Return last value from a row on another tab

    Hi guys,

    Need help retrieving a value from a row on another tab. On my sheet, on project planner snapshot tab in celll D13,

    i WOULD like to have the last value from range: N14:X14 on the actions tab returned. How do I do this please?

    thank you!
    Attached Files Attached Files
    Thanks,

    R.



  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Return last value from a row on another tab

    Please try

    =LOOKUP("Z",Actions!N14:X14)
    Attached Files Attached Files

+ 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. Replies: 6
    Last Post: 02-22-2021, 05:27 PM
  2. [SOLVED] IF logical test pass return with 1st LOOKUP if true, if false then return with 2nd VLOOKUP
    By powerzasty in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-21-2017, 03:55 PM
  3. [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
  4. Replies: 2
    Last Post: 05-07-2015, 04:38 PM
  5. 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
  6. Replies: 4
    Last Post: 03-13-2013, 12:38 PM
  7. Replies: 6
    Last Post: 10-11-2012, 02:39 PM

Tags for this Thread

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