Formula Assistance

Question

Hi there!
I am trying to run an excel formula and can't seem to figure it out. I have a column with a range of numbers in one tab and a column with a range of numbers in a separate tab. I am trying to create a formula, where it searches the first column and if it finds a match anywhere in the second column it adds/sums any/all amount(s) from another column in the second tab. Hope this makes sense! Thank you!