I have data in column A from A9 to A15 and data from C9 to C15. Now I want to compare cells C9 to C15 with another cell C20 and if data in a cell is same, let us consider C5 is same with C20, then I want to print the A5 to another cell C21. I'm not an expert so please provide me any method including VBA and macro so that I can learn.Basic.jpgAttachment 266105