Results 1 to 6 of 6

Vlookup and Hlookup combined

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-29-2011
    Location
    Cape Town
    MS-Off Ver
    Excel 2010
    Posts
    107

    Vlookup and Hlookup combined

    Hi,

    I'm not sure if I need a vlookup and and hlookup in a single formula.

    I have attached a workbook. In short I have two tables and the cells highlighted in yellow need to pull the correct figures from the above table. Basically it need to read off an intersection.

    Any help would be appreciated.

    Thanks!
    Attached Files Attached Files
    Last edited by concatch; 10-30-2013 at 10:30 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Is there a combined VLOOKUP & HLOOKUP function?
    By AndyGW in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-04-2012, 10:08 AM
  2. [SOLVED] VLookup and HLookup Combined?
    By Jmarsh4 in forum Excel General
    Replies: 2
    Last Post: 05-15-2012, 01:44 PM
  3. Hlookup and Vlookup Combined (Match?)
    By batman1056 in forum Excel General
    Replies: 3
    Last Post: 06-21-2010, 04:33 PM
  4. VLookup and Hlookup combined using separate workbooks
    By trentonm in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2008, 03:18 PM
  5. Offset And Hlookup Combined
    By gacollege in forum Excel General
    Replies: 4
    Last Post: 01-28-2005, 01:45 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