Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
index and Match
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,
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?