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
2 Replies
Try
=SUBSTITUTE(XLOOKUP(I5, M5:Q5, M4:Q4, "not found"), " Quote Amt", "")
Hi, Victor1123 !
One option could be:
=XLOOKUP(I5,HSTACK(M5,O5,Q5),HSTACK(M$4,O$4,Q$4),"Not Found")Blessings!
