index and Match

billing10428

Hi Community 

 

Im having an issue with index and match 4

 

i have imported from Excel 

 

the sheet is set as follows 

Item Name Vendor name 1  vendor rate 2 etc,

 

Example 

Item #102 Rate on vendor 1 20.00 rate on vendor 2 25.00 then i have a coulmn calculating the best price =min on vendor 1-vendor 2

and by best name i want it to come the name of the vendor that is the Cheapest 

 

so i did =INDEX($Certfied$1:$Levrage$1, ,MATCH([Best Price]12,Certfied12:Levrage12,0))

 

if anybody can tell me what im doing worng ?

 

or if smart sheet dose not have this Formula?

J. Craig Williams

billing,

 

A picture might help (your formula example does not match the column names in the description) but I suspect that your collection (the first argument of INDEX()) is too small.

 

You also have two commas without an argument for argument 2.

 

What are you trying to return from your table?

 

Craig