Hi -
I'm wondering if someone can help me out. I have a table that has carrier name and below the name is the various prices. Some carriers will have "N/A" if they do not service certain regions. I'm trying to find a way that will review all the rates and provide to me the carrier name that offers the cheapest rate. I've tried to ways to accomplish this but I'm getting an error.
1st way was
In which cell c87 was created to pull the minimum rate.
2nd way was
Both ways are giving me N/A. Is it because some of the values in my table have "N/A"?
Any help is greatly appreciated.
I'm wondering if someone can help me out. I have a table that has carrier name and below the name is the various prices. Some carriers will have "N/A" if they do not service certain regions. I'm trying to find a way that will review all the rates and provide to me the carrier name that offers the cheapest rate. I've tried to ways to accomplish this but I'm getting an error.
1st way was
Code:
=INDEX(F55:M55,MATCH(C87,$F$56:$O$59,0))
2nd way was
Code:
=INDEX(F55:M55,MATCH(MIN(F56:O59),F56:O59,0))
Both ways are giving me N/A. Is it because some of the values in my table have "N/A"?
Any help is greatly appreciated.