Return date based on 2 criteria

dunmore83

Well-known Member
Joined
Aug 24, 2011
Messages
540
A B C D
2 26/11/2013 144
10 03/09/2013 345
144 438
345 04/10/2013 1168
438 05/10/2013 1442
500 1528
550 25/11/2013 1611
1442 1612
1528 25/10/2013 1617
1600 25/09/2013 1629

In column D I need the date that lines up with the same number in column A. For example if 345 from column C is found in column A then return the date in column B which is 04/10/2013 & this will be place in D2; otherwise return 0 (i.e. if the search was for 1442 result would be 0)

Can someone please help with this problem?

THANKS!
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Forum statistics

Threads
1,215,877
Messages
6,127,494
Members
449,385
Latest member
KMGLarson

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top