View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
soonic soonic is offline
external usenet poster
 
Posts: 9
Default finding a value with parameters

Uzytkownik "Jarek Kujawa" napisal w wiadomosci
...
=MIN(IF($A$2:$A$5="j",$B$2:$B$5))
array-enter this formula i.e. with CTRL+SHIFT+ENTER instead of using
ENTER only



thank you, but this is the first part. In final answer should be a value
from col A as the same row of found number in C.
It doesn't work with my example.
Col A have values A1, A2, A3, A4. The answer should be "A3".