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.

​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.  Read More

​