+ Reply to Thread
Results 1 to 3 of 3

Lookup not working

  1. #1
    Forum Contributor
    Join Date
    10-29-2004
    Posts
    291

    Lookup not working

    https://docs.google.com/spreadsheets...it?usp=sharing

    =LOOKUP(2,1/(TEXT(E$1:E,"#####")=TEXT(A1,"#####")),F$1:F)

    I'm using this formula to try and find the last occurrence of a value within the E column and return the adjacent value from the F column. I'm trying to force the criteria to search using a text format. It doesn't seem to want to work.

  2. #2
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: Lookup not working

    Try,
    Please Login or Register  to view this content.
    or,
    Please Login or Register  to view this content.

    where the following formula will give you the last value in column E:
    Please Login or Register  to view this content.
    Best,
    berlan

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Lookup not working

    Hi djarcadian,

    Since column E contains numeric values you shouldn't be using text to lookup numbers.

    Use this formula to get the date from column F

    12345 is entered as number in cell A1

    =LOOKUP(2,1/(E$1:E$16=A1),F$1:F$16)
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ 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. LOOKUP formula not working
    By dwilkinson12 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2014, 09:00 AM
  2. Lookup not working
    By penfold in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-05-2012, 11:44 AM
  3. lookup not working
    By dougmorgan in forum Excel General
    Replies: 7
    Last Post: 08-22-2010, 05:30 PM
  4. LookUP <> not working
    By penfold in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-13-2010, 12:52 PM
  5. Lookup Function not working
    By hcamelion in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-05-2006, 02:25 AM

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