Results 1 to 6 of 6

Vlookup and Hlookup combined

Threaded View

  1. 07-07-2017, 09:31 AM #6
    SHIV SHANKAR
    SHIV SHANKAR is offline
    Registered User
    Join Date
    01-03-2017
    Location
    DELHI , INDIA
    MS-Off Ver
    2007
    Posts
    3

    Re: Vlookup and Hlookup combined

    concatch
    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.


    Hey Buddy here is the solution of your problem. You can download the sheet and check it.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1