+ Reply to Thread
Results 1 to 4 of 4

Lookup from another sheet

  1. #1
    Registered User
    Join Date
    06-16-2018
    Location
    Manchester, England
    MS-Off Ver
    2016
    Posts
    138

    Lookup from another sheet

    =LOOKUP(9.99999999999999E+307, A:A)

    This formula finds the value at the bottom of its range.
    I want to use this formula to search a different sheet but I can't work out where I should add 'sheet' 2 to it.

    Can someone help with this?

    Thanks

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Lookup from another sheet

    If you are searching in Sheet2
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If your sheet name has spaces in it (i.e. Sheet 2), you need to use single quotes like so
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    06-16-2018
    Location
    Manchester, England
    MS-Off Ver
    2016
    Posts
    138

    Re: Lookup from another sheet

    Many thanks

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

    Re: Lookup from another sheet

    Please try

    =LOOKUP(9^9,sheet2!A:A)
    or
    =LOOKUP(99^99,'sheet2'!A:A)

+ 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. [SOLVED] Lookup values on another sheet and change background color on current sheet
    By x65140 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2019, 08:15 AM
  2. Replies: 6
    Last Post: 07-26-2015, 03:43 AM
  3. Lookup Value from Sheet 4 in Sheet 2, if found copy Sheet 2 Active Row to Sheet 5
    By lgosso23 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-11-2013, 02:51 PM
  4. [SOLVED] Excel Macro to lookup sheet name with a range of cells and paste in the reference sheet
    By mishaq in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-08-2013, 02:55 PM
  5. [SOLVED] Lookup up from Sheet 1 in Sheet 2 and display additional value in Sheet 1 when match
    By azbridgie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-31-2013, 03:22 PM
  6. Replies: 1
    Last Post: 11-07-2012, 01:57 PM
  7. Replies: 11
    Last Post: 10-14-2012, 01:03 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