Forum Discussion
Victor1123
Nov 11, 2025Copper Contributor
Excel - Showing which Carrier is used based on selected quote cost
Hello, I am looking for a formula to show me which carrier is being used based on the selected quote column (J5). I need the formula to tell me which quote is selected (Columns M/O/Q for example) in...
m_tarler
Nov 12, 2025Bronze Contributor
Try
=SUBSTITUTE(XLOOKUP(I5, M5:Q5, M4:Q4, "not found"), " Quote Amt", "")