Francis Gerard Tupaz
Member
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
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