Results 1 to 4 of 4

Vlookup for multiple criteria using multiple table arrays

Threaded View

  1. #1
    Registered User
    Join Date
    06-18-2019
    Location
    Dallas, Texas
    MS-Off Ver
    windows 2013
    Posts
    72

    Vlookup for multiple criteria using multiple table arrays

    I have a Vlookup that works great - But I am trying to implement some changes to auto select or formula that knows which array to use, as opposed to using the same range since it changes with date.

    Attached is a sample data file with the Headers: Pricing Date, Year, Benchmark, YLD, SPRD

    The lookup is pulling the benchmark number from the "Selected Bench" Tab. Is there a way to adjust the formula to pull from a different array depending on whatever the pricing date may be?

    Any help would be appreciated, 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. VLOOKUP from multiple table arrays
    By russkris in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-13-2022, 10:07 PM
  2. Vlookup using multiple criteria from table
    By sryadav12 in forum Excel General
    Replies: 4
    Last Post: 05-05-2021, 07:09 AM
  3. [SOLVED] Summing multiple arrays with multiple criteria
    By Kingofthehild in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-04-2020, 12:21 AM
  4. Replies: 4
    Last Post: 03-13-2018, 07:15 AM
  5. Fill arrays from sheet / SUMIFS / create & fill table based on multiple criteria
    By Dimitris254 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2016, 09:43 AM
  6. [SOLVED] Vlookup multiple table arrays
    By TheBakerBoy in forum Excel General
    Replies: 2
    Last Post: 12-09-2015, 08:32 PM
  7. [SOLVED] Vlookup in multiple arrays
    By Rbp9ad in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-28-2005, 11:05 PM

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