+ Reply to Thread
Results 1 to 3 of 3

LOOKUP Last entry in a column

  1. #1
    Registered User
    Join Date
    06-03-2017
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    10

    LOOKUP Last entry in a column

    I am using the formula =LOOKUP(2,1/(1-ISBLANK(H:H)),H:H) in cell H1

    to give me the last entry in column H which enters into a fixed location at the top of that column in H1. I then can use the cell H1 later in other calculations.

    The problem is that the formula only works if column H is one that I fill in the entry manually.

    If I use down the length of that column formulas which get that entry from another calculation from other cells, then the cell at the top (H1) where I want the last entry shown, is just blank.

    How can I alter the ISBLANK function in my formula to solve this problem? Or do I need to use a different formula for this?

    Thanks, Dennis

  2. #2
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: LOOKUP Last entry in a column

    Possibly in H1:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Geoff

    Did I help significantly? If you wish, click on * Add Reputation to say thanks.
    If your problem has been resolved please select ?Solved? from the Thread Tools menu

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2021
    Posts
    6,137

    Re: LOOKUP Last entry in a column

    Or try:

    =LOOKUP(2,1/(H2:H100<>""),H2:H100)

+ 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. If mySQL database column entry matches excel column entry, then...
    By khelza in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2015, 02:34 PM
  2. [SOLVED] Replace LOOKUP formula in colunms A & C, fill to last row when entry into cell in column B
    By gpato in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2014, 08:10 AM
  3. Replies: 1
    Last Post: 11-13-2013, 04:03 PM
  4. [SOLVED] Lookup column and display last text entry
    By Spankyf in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-16-2012, 02:36 PM
  5. Replies: 0
    Last Post: 10-06-2011, 07:03 AM
  6. Lookup multiple coloums and return corresponding column entry
    By prashe in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-26-2011, 11:14 PM
  7. [SOLVED] Lookup last entry in column
    By Angelo Sartore in forum Excel General
    Replies: 3
    Last Post: 03-16-2005, 08:06 AM

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