Results 1 to 2 of 2

Thread: VlookUp or Match

  1. #1
    Acolyte Francis Gerard Tupaz's Avatar
    Join Date
    Jun 2012
    Location
    Philippines
    Posts
    30
    Articles
    0
    Excel Version
    2011

    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.

    Thanks.

    Francis
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,479
    Articles
    0
    Excel Version
    365
    try:
    =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
  •