How to extract relevant column data in excel 2003

Hello friends,

I want to
a) extract one column data specific to the relevant keys input in another column.
b) Copy these data in another excel sheet, in the same work book

Highly appreciate any help.

Joe

Welcome to the forum, Joe.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

Hi Joe;

Are you saying:
I want to find all the values in Column A that match the value in D3, and copy the corresponding values in Column B to another sheet.