Hi,
We want to check, match and get data from two sheet as per attached excel sheet
We will check and match if Range K8:P8 will match Range A8:A18 and if there is Yes in B8:B18 then it will copy the S.No. and heading and paste in sheet1 column,
Again formula will check the with the range K9:P9 and then next and next and next
Sheet1 from where we will compare and match and get the result, please check the sheet1 heading Result
help pls
Bookmarks