+ Reply to Thread
Results 1 to 3 of 3

Problem using LOOKUP...

Hybrid View

shyguy14 Problem using LOOKUP... 05-29-2008, 12:07 AM
davesexcel Hi, This type of Vlookup... 05-29-2008, 12:37 AM
protonLeah Say you have your values in... 05-29-2008, 12:48 AM
  1. #1
    Registered User
    Join Date
    05-29-2008
    Posts
    1

    Problem using LOOKUP...

    Hi, this seems like it should be really simple but i just can't work it out.

    I have one column of figures, the values of which increase and decrease as i add values to the column. So, for example:

    200
    210
    150
    180
    240
    120

    Now, i am referencing this column in other cell, and all i want it to do it to find and display the most recent figure added. So using the above data, i want it to show '120'. At the moment, I'm using MAX as the lookup_value, which never felt right and is now proving me right as it's displaying '240' as it's the highest value in the column.

    If anybody could point me in the right direction of displaying the latest figure, i would be most obliged!

    john
    Last edited by VBA Noob; 05-29-2008 at 01:56 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525
    Hi,
    This type of Vlookup will display the last value in column B
    =VLOOKUP(9.99999999999999E+307,B:B,1)

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,920
    Say you have your values in column H starting at row H1 and you have unused cells at J1 and K1. In J1 put the formula:
    ="H" & COUNT(H:H)
    in K1 put:
    =INDIRECT(J1)
    The first formula will create the address of the last used cell in H; the second will use the address built-up in J to fetch the last cell in H.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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