+ Reply to Thread
Results 1 to 6 of 6

lookups in excel with weird formatting

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    lookups in excel with weird formatting

    Hello I'm trying to a lookup table but I'm not sure how to do it based on the formatting (attached is a sample). Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: lookups in excel with weird formatting

    =sumproduct((a4:a9=j4)*(a5:a10=k3)*(b5:b10))

    or

    =lookup(2,1/((a4:a13=j4)*(a5:a14=k3)),b5:b14)
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    Re: lookups in excel with weird formatting

    That doesn't work. It returns errors.

  4. #4
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: lookups in excel with weird formatting

    How about INDIRECT instead?

    =INDIRECT("B" & MATCH(K$3,OFFSET($A$1:$A$3,MATCH($J4,$A$1:$A$13,0),0),0)+MATCH($J4,$A$1:$A$13,0))
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    Re: lookups in excel with weird formatting

    boom boom pau. Thanks.

  6. #6
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: lookups in excel with weird formatting

    No problemo

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] date formatting is acting weird.
    By ammartino44 in forum Excel General
    Replies: 11
    Last Post: 04-13-2015, 02:53 AM
  2. Lookups for Financial Statement Formatting
    By amartino44 in forum Excel General
    Replies: 2
    Last Post: 12-17-2012, 03:09 PM
  3. Laptop + Win 7 + Excel = Weird formatting?
    By j1burn in forum Excel General
    Replies: 4
    Last Post: 07-04-2010, 05:34 PM
  4. Weird Excel date formatting problem
    By Ian D in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-21-2005, 11:05 AM
  5. weird formatting
    By Ed in forum Excel General
    Replies: 0
    Last Post: 06-09-2005, 03:05 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