if you have a range of values in one column and you want to see if a value from another column is in that range you can use a combination of the match and index functions to get the value of the match
http://www.mrexcel.com/articles/excel-vlookup-index-match.php
No comments:
Post a Comment