Hi,

As attached, I am trying to automate "Hinge Dist From Side" a little more. I am struggling to use the 'SEARCH' function to read 0mm or 3mm in the appropriate column. My understanding of this function is limited and it may well be I am using the wrong function for this. I know that I can accomplish this through other methods but I was hoping to further my knowledge on this function with your help and if it is not appropriate to use here, understand the reason(s) why.

Thank you