Results 1 to 10 of 10

Vlookup with MATCH? Better than nested Vlookups?

Threaded View

  1. #1
    Registered User
    Join Date
    08-08-2010
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2010
    Posts
    85

    Thumbs up Vlookup with MATCH? Better than nested Vlookups?

    Hi there
    I'm trying to find the best way to lookup values off a pivot table, however the required tag in the first column only appears once. I need to tell the formula that when it sees the tag "Q1" for example to then lookup the info starting from the column next. That's fine for the first row's formula, but the second to forth need to say, Once the tag "Q1" is found (wherever that is), lookup starting from 1 row below, or 2 rows below etc.

    Or maybe I should be using offset?MATCH help.xlsx

    I have attached the example as I'm sure it's easier to understand visually!
    Last edited by trillium; 12-29-2015 at 05:24 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Nested If and Vlookups
    By lorber123 in forum Excel General
    Replies: 4
    Last Post: 05-18-2014, 12:48 PM
  2. Nested IF/MATCH/ISERROR with VLOOKUP
    By Neyme in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-12-2014, 10:29 AM
  3. Nested Vlookups?
    By tenscourts in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-19-2012, 06:03 AM
  4. Excel 2007 : Nested IF, Vlookup and Match, or?
    By Helal in forum Excel General
    Replies: 4
    Last Post: 12-03-2011, 12:40 AM
  5. Nested Vlookup & Match
    By Helal in forum Excel General
    Replies: 3
    Last Post: 03-06-2011, 07:00 PM
  6. Nested index, vlookup and match
    By Maddyv in forum Excel General
    Replies: 4
    Last Post: 02-02-2010, 02:51 PM
  7. Nested IFs and VLOOKUPs
    By Johny1 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-26-2009, 07:11 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