I need assistance with a simple excel formula, with which i have been
struggling.

the file I am working a has column that has data from another sheet(using
vlookup).

I have to use this data again to find the lowest score is. I use Mi() to
find the lowest score. However, as the cell contains a formula, the min
calculates any empty lookup as a 0, thereby, automatically using this as the
lowest entry.

Could we arrange a formula that ignores any entries that are 0 in a range of
cell.