Multiple array in Vlookup

[moxeve]

hello guys,
i have two different workbook and i want to find how much X person paid me,

person X got two service from my company one is 150$ and second 300$, this two number is in A and B worksheets and i want find useing vlookup or other function, how much did person x paid in service A


=Vlookup(person X,array1 & array2,clmn nm2, )

and how can i add this to array in one formula

 

[istiasztalos]

hi moxeve,

Vlookup or similar lookups would only return 1 value

You could try to use SUMIF to sum payments from one sheet and another one from the other sheet, like

=SUMIF(sheetA!namelist,personX,sheetA!pricelist)+SUMIF(sheetB!namelist,personX,sheetB!pricelist)

 

[moxeve]

thanks for reply istiasztalos ,

this formula can be useful for me in this question, but if i have text and not number and want to search witch services made person X for me?

 

[istiasztalos]

Hi,

Limitation is limilar, VLOOKUP or similar formulas can only return 1 result, that would work as long as a person has only one record on each sheet.

If they possibly used multiple services than I would recommend a pivot table