I'm looking for a formula in to display a number (cost) in a specific cell if another specific cell contains text (address).
At the moment I have 4 columns. One for location (E2 : E146), one for Cost (M2 : M146), one with all the addresses (N2:N146) and one for the total cost (Q2:Q146).
I need column M to pull through the cost of column Q if column E contains one of the addresses from Column N.
Hopefully this makes sense as I'm pretty new to excel and formulas.
Thank you in advance.