Results 1 to 1 of 1
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Pontiac, Michigan, USA
    Thanked 0 Times in 0 Posts

    Combine Vlookup & Mod Formulas (2007)

    Would someone be able to show me how to combine the formulas in F6 and G6?

    The idea is to make sure that the quantity ordered is a multiple of the standard pack. Everything does work as it stands. However, I would like to have the formulas combined. Can this be done? If so, how?


    On Edit: Never mind. I got it to work this time. Here's what I came up with:

    =IF(MOD($C6,VLOOKUP(Order!A6,PriceList!$A$1:$D$4,4 ))=0,"OK","Change Pack Qty")
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts