+ Reply to Thread
Results 1 to 4 of 4

Lookup up a value off another sheet according to nonblank x,y position.

  1. #1
    Registered User
    Join Date
    10-10-2014
    Location
    finland
    MS-Off Ver
    excel 2013
    Posts
    2

    Lookup up a value off another sheet according to nonblank x,y position.

    Hi,

    I've been trying to make a formula, which does the following:

    I have 5 numbers which are references:

    So sheet 2: cells B2:B6 could get dates from Sheet 1 field_array named field according to A2-A6

    **Edited: this is so hard to explain. i'd like to lookup vertically the first nonblank cell in array and then lookup the date from the column of that nonblank cell.

    1) Find the cell position of the first nonblank cell according to number in column A on sheet 1.

    2) Return the date from range Sheet1!B1:F1 for the number.

    So the result should of the formula would be in sheet 2:
    A B
    1 | 2102 | 2.1.2015
    2 | 2103 | 1.1.2015
    3 | 2104 | 4.1.2015
    4 | 2015 | 3.1.2015
    5 | 2106 | 5.1.2015

    Any ideas how to make this work? Sorry if you didn't get my idea... It's basically finding a field according to position. So i'd like to lookup vertically the first nonblank cell in array and then lookup the date from the column of that nonblank cell.

    [table="width: 500, class: grid"]
    worksheet.xlsx

  2. #2
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Lookup up a value off another sheet according to nonblank x,y position.

    Hi, Ref the attachment
    Click just below left if it helps, Boo?ath?

  3. #3
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Lookup up a value off another sheet according to nonblank x,y position.

    Hi, Refer the attachment
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-10-2014
    Location
    finland
    MS-Off Ver
    excel 2013
    Posts
    2

    Re: Lookup up a value off another sheet according to nonblank x,y position.

    Dude, thanks alot. that is awesome.

+ 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. Best way to check nonblank cell count for sheet(s) and compare them
    By kaysee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-29-2014, 02:38 PM
  2. Lookup a value, and SUM relative to that value position
    By gtichauer in forum Excel General
    Replies: 2
    Last Post: 01-17-2012, 04:44 PM
  3. Replies: 2
    Last Post: 12-22-2011, 07:05 PM
  4. Formula to retrieve data from the latest nonblank sheet
    By trickydigger in forum Excel General
    Replies: 5
    Last Post: 01-26-2011, 09:10 PM
  5. VBA to lookup Position for region by approval amount
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-20-2008, 10:04 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