index match return value

@TMS i tried replying to your earlier quote with the code but it didn't seem to work, however your code was awesome and worked a treat.

thanks so much you've completely answered my question and then some, ill leave this thread for now and post my other questions (although related to this workbook I'm making) in new threads in the appropriate places.

cheers!