MIN Function: 3 columns with formula results

[Twinkievizzio11]

Hello,
I have 3 columns using a vlookup to pull data from other worksheets. Then i want to find the MIN excluding zeros. I tried so many formulas and it is not working. Please help!

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

If you have 2019 or newer then you could use the MINIFS function

 

[awoohaw]

can you provide and xl2bb example of what the worksheet looks like and your formulas?
What is the error message you get?

 

[Twinkievizzio11]

I was not able to provide a sample as the data is sensitive. However, i added the Value function to the beginning of my vlookup and now the MIN function works!!

 

[Fluff]

Glad you sorted it & thanks for the feedback.