I have a project to do in metallic structures, and in one of the cases I need to say which profile is approved with the lowest mass, but when I do this it is returning the wrong value. It works as follows (my Excel is in Portuguese, I don't know if they are the same names): the "minimoses" function is used to find the smallest value of a matrix with criteria whether it was approved. For the next step I used the "match" function, when using it I related the result of the previous function so that it could search for the number found in an array that I inserted. The problem is that it returns the position of the number 25.3 and the number reported by the "minimoses" function is 28.3 and thus tells me the wrong metal profile. At first I changed it to "procv" but it wasn't enough to solve it, the solution I found was to add "match" to 7, that way it gives me the right profile. This makes it lose its meaning, since the idea is to automate it and not to be a fixed answer. If anyone can provide a solution or suggestion, I would appreciate it. Sorry if anything is written wrong.
