Results 1 to 20 of 33

Thread: help needed with Vlookup and IF function

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-14-2015, 10:46 PM #1
    LearningEXL
    LearningEXL is offline
    VBAX Regular
    Joined
    Apr 2015
    Posts
    32
    Location

    help needed with Vlookup and IF function

    Hi

    can anyone help me with this formula please.

    =VLOOKUP(D9,Agency_Contract!C9:Y11,22,IF(J9>Agency_Contract!X9,J9-Agency_Contract!X9,0))
    its just not doing what i want it to do.

    vlookup references based on a D9

    IF is what i want it to do

    ive even tried it like this but this one just returns the value in J9 but i dont want that to happen

    =IF(J10>Agency_Contract!X10,J10-Agency_Contract!X10,VLOOKUP(D10,Agency_Contract!C10:Y12,22))
    Last edited by LearningEXL; 04-14-2015 at 11:14 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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