Forum

Hi Sunny, I'm still not able to get the formula to work on my worksheet? Is it because in my worksheet the Hotel column is before the Hotel Group c...

Hi Sunny, I tried applying the formula to my spreadsheet but could not get it to work, not sure if the issue is because the lookup values are on an...

Thanks Sunny Great help

Thanks Sunny

Thanks Sunny Issue solved, fantastic help Regards Paul

Hi Sunny, Really sorry but have found an issue, when I updated the other columns to have W1, W2, W3 etc the formula does not work as it does not re...

Thanks Sunny, You are a star!!! Regards Paul

sorry forgot to attach file

Hi Sunny, Thanks for the reply, however unable to make the formula work due to how the info is laid out, have attached a 'clean' version of the rep...

Thank you Sunny & Clark for giving me the answer with different solutions, great, gives me options plus have learned a lot Regards Paul