Results 1 to 2 of 2

Thread: VlookUp or Match

  1. #1

    VlookUp or Match

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Dear All,

    May I request for your help please?

    I am trying to get a data if 2 criteria is a match, for example if the Currency is USD and the item is $5 Load Denomination the amount reflected should be 5$, should I use v-lookup or match? If its v-look up can you please teach me how as I do not know how to do v-lookup with multiple criteria? If its match or something else can anyone teach me how because I simply dont know how to do use other formulas.
    I have attached herewith the excel sample for easier reference.


    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Excel Version
    =SUMPRODUCT(('Product List'!$A$5:$A$125=$E$3)*('Product List'!$B$5:$B$125=$B5),'Product List'!$D$5:$D$125)
    in E5 and copy down.
    This will only give the correct result if there is only one match of currency/product name; if there is more than one match then those values will be summed.

    Put consideration to a pivot table, it's a lot easier.

Posting Permissions

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