Hi,
i like to set up formula in which i can search/match diff cell and return the value i want in a new cell. i attach below.
for example
i have first 3 column contain vendor A (with code) vendor B (with code) and month 1, 2

In other cell i have vendor A with amount per month.
what i want to have it at the column result they will search for me if the amount of vendor A with code match with the vendor A at the right side then the code will be shown up in the column result.
any one can help me pleas


Vendor A 1 2 Row Labels 1 2 Grand Total Result
20091692 74.821 74.821 Vendor A 139.382 150.957 290.339
20092902 150.957 150.957 Vendor B 63.005 61.835 124.840
Vendor B
20092082 65.874 65.874