Forum Discussion
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 J5 based on the selected quote amount in I5.
Thank you in advance.
Victor
1 Reply
Try
=SUBSTITUTE(XLOOKUP(I5, M5:Q5, M4:Q4, "not found"), " Quote Amt", "")
