Hi,
I would like to enter data from sheet1 to appropriate fields in sheet2 (as shown in example). I thought I could do this with match and index formula, but am having problems, due to many criteria and big search field in sheet 1. Any ideas for help?
forum.ozgrid.com/index.php?attachment/71774/
Thanks,