im looking for a formula that will find a cell the a certian cell with "CMR107" and return the value above it which would be 26,011,010.27


2,849,484.55 0.11 0.65
1,571,265.55 0.06 0.36
26,011,010.27 1.00 5.49
CMR107 CMR112

2,154,372.55 0.29 1.76


does anyone know how to?