Results 1 to 2 of 2

How to have 2 tables inside Vlookup function?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-01-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    280

    How to have 2 tables inside Vlookup function?

    Hi,

    How do I insert another table inside a vlookup function?

    this is my current one:

    =VLOOKUP(A1,Sheet2!A1:B3,2,FALSE)

    But I have another sheet..

    How can this current formula be changed to search between two tables (Which are in seperate sheets)

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. INDIRECT/ADDRESS inside LINEST function versus inside INTERCEPT
    By slny06 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2019, 08:51 AM
  2. [SOLVED] Use Left Function Inside Vlookup()
    By jo15765 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-21-2017, 09:11 PM
  3. RAND function nested inside a VLOOKUP
    By SuperWhistle in forum Excel General
    Replies: 2
    Last Post: 11-04-2016, 12:58 AM
  4. Vlookup inside IF function not working
    By Ruby91 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-07-2014, 10:30 AM
  5. [SOLVED] Vlookup function from 2 pivot tables data
    By in nomine noctis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-08-2013, 09:29 AM
  6. Help with file path inside VLOOKUP function
    By acpt22 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-25-2013, 05:51 AM
  7. Replies: 1
    Last Post: 10-02-2012, 04:27 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