+ Reply to Thread
Results 1 to 3 of 3

2 lookup formulas at the same time

  1. #1
    Registered User
    Join Date
    03-07-2017
    Location
    Ontario
    MS-Off Ver
    2010
    Posts
    21

    2 lookup formulas at the same time

    I am trying to create a formula to give me the number on the same line if the text in two other cells equals my criteria. I have attached the workbook
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: 2 lookup formulas at the same time

    Don't get stuck thinking inside the vlookup box

    =SUMIFS(sat!F:F,sat!A:A,C2,sat!B:B,"Cash from sale")

  3. #3
    Registered User
    Join Date
    03-07-2017
    Location
    Ontario
    MS-Off Ver
    2010
    Posts
    21

    Re: 2 lookup formulas at the same time

    Oh dear lord! I was making if far more difficult. Thanks so much

+ 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. Replies: 5
    Last Post: 09-25-2013, 02:51 PM
  2. Replies: 3
    Last Post: 11-21-2012, 05:47 AM
  3. Time formulas + Conditional formulas for time
    By asharris in forum Excel General
    Replies: 1
    Last Post: 09-18-2012, 09:17 AM
  4. Lookup formulas
    By tinoca in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-03-2012, 08:20 AM
  5. Excel Formulas for Calculating Straight, Over Time & Double Time in Cost Estimating
    By redhairredhair in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2010, 09:06 PM
  6. Lookup formulas
    By evt123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2010, 06:13 PM
  7. Lookup formulas
    By Heather O'Malley in forum Excel General
    Replies: 1
    Last Post: 06-14-2006, 07:00 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