ExcelForumHelp.jpg

Good day all and happy new year.

The data I'm dealing with is larger therefore I've simplified it to the above image. I'll do my best to explain what I would like to achieve. I've not started on the VBA codes yet as I don't know where to begin from and my level in VBA is just a beginner.

As you can see from the image attached, I'd like to have all the information in the whole of column A (taking into account that column A may expand as it depends on the data that is fed in from another sheet - thus the selection of column A has to be able to expand automatically)

and compare it with information in Column F, Column H and Column J (data in this columns are fixed and need not to be expand), on another note, Column F, H and J are in another worksheet (say "Sheet 2").

Once the comparison is done, I'd like to have the result shown in Column B indicating "Priority 1" if it is from Column F, "Priority 2" if it is from Column H and "Priority 3" if it is from Column J.

Apologies if this has been answered in another thread however I tried searching around but I couldn't find the right key words to put together to find the solution that fits.

Big thanks in advance,
Aaron