problem regarding copying reference row name to a cell if condition is true.

[dego]

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

[protonLeah]

To attach a Workbook
(please * do not post pictures * of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"