Can someone help me on a formula. I have 2 sheets in a workbook and what I need is. If ColumnT and ColumnI on sheet1 match ColumnD and ColumnG on sheet2 then what percentage is the value in ColumnQ on sheet1 of the value in ColumnH on sheet2.
T I Q D G H
Car 15325 40 Car 15325 1000
Would return on sheet1 in the column ran 400