Results 1 to 6 of 6

Lookup a vertical and horizontal value

Threaded View

  1. #1
    Registered User
    Join Date
    04-10-2013
    Location
    Albuquerque
    MS-Off Ver
    Excel 2010
    Posts
    5

    Lookup a vertical and horizontal value

    I have attached a sample spreadsheet. I need a lookup formula of some type in C3 that will look at the value in Column A3 (the version) and the value in C1 (will always be the reference for all formulas in column C. This is the position number) then goes to the worksheet named Actual Dates and finds Version in column A and the Position in column B then returns the corresponding date from Column C to the first worksheet named Comparison.

    I tried a vlookup with an if statement but got an error message. Am I trying to get a formula to do too much?

    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. [SOLVED] Lookup with THREE conditions: one vertical, two horizontal
    By splendidus in forum Excel General
    Replies: 7
    Last Post: 08-05-2014, 01:11 PM
  2. Horizontal and Vertical lookup.
    By rlsublime in forum Excel General
    Replies: 3
    Last Post: 09-05-2012, 05:54 PM
  3. [SOLVED] Reverse Horizontal Lookup From A Vertical Code
    By splendidus in forum Excel General
    Replies: 4
    Last Post: 05-29-2012, 07:39 AM
  4. Replies: 1
    Last Post: 04-12-2011, 07:18 PM
  5. Replies: 4
    Last Post: 11-30-2008, 04:55 AM

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