Matching Columns from different worksheet

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I am trying to match project codes in different work sheets and display the date.

Column E5 worksheet Contract award to match worksheet 'All CAs'Column A1 and then display the date which is in worksheet 'All CAs'Column E, if a match is found.

Any advice would be much appreciated.


Regards

Graeme

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Can you add a sample file at some file sharing site and post the link of the file back here