Data Validation

Hi, I am not sure what the best formulate to use, to extract the 'customer's rates' without retyping their rates manually. E.g. If I need to get the 'ABC rates (or other customer rates in column F, G, H)' from G column is there an easy way of pulling the data without manually typing them each line that will calculate the total costs?

Thank you.