Try this in B9: =B1&INDIRECT("A"&MATCH("Yes",B2:B6,0)+1) Hope this helps
Click here for a guide on how to add code tags Click here for a guide on how to mark a thread as solved Click here for a guide on how to upload a file with your post Excel 365, Version 2408, Build 17928.20080
Forum Rules
Reply With Quote