How can I obtain a value in one column based on another column in excel?
<p>Suppose I have two columns; A and B. each of which has 50 rows of data. I want to set the value of a third column, C, to the value of A corresponding to, say, the minimum value of B. Can I do this without writing a macro?</p>

<p><a href="https://qph.is.quoracdn.net/main-qimg-7978d7e50a58000fc152952a980c09e3?convert_to_webp=true" rel="nofollow">https://qph.is.quoracdn.net/main-qimg-7978d7e50a58000fc152952a980c09e3?convert_to_webp=true</a></p>