Hi, any assistance would be greatly appreciated.
Attached is the lookup table and the input/output result.
I am not sure if a macro is better or if formula (index match formula) would be quicker. Kindly let me know, how to achieve the output?Sample.xls
Thanks!
Bookmarks