IF statement help

[JesseF1005]

I am trying to make a table that corresponds to data in another table.

I have column A5:A30 set up with supplier names, and column J5:J30 set up with costs associated with that supplier.

Down below this table I have A32:A40 with Supplier names, and B32:B40 with their original costs.

I am trying to get column C32:C40 to show me the final costs by using an IF statement. If row 5 has "supplier name" in column a, add B32+J5.

I can make the if statement work once, but I am trying to get it to add the original cost in B32 plus any value in J5:30 if column a has that specific supplier's name.

Any help can be appreciated.

[#2]

@JesseF1005 

In C32:

=B32+XLOOKUP(A32, $A$5:$A$30, $J$5:$J$30, 0)

Fill down.

[#3]

Thank you! This seems to work for the first value in column J that corresponds with the name in Column A, but does not compute the remaining ones if I have duplicates in column A. Any advice?

[#4]

=F40+SUMIF(Table1[Supplier],E40,Table1[SC AMOUNT])

Was the formula I found that worked. I needed a sum if formula.