Return value from column A if match to column D

T

Terri

It's Friday and my brain has stopped functioning, I have two worksheets, WS1
and WS2, what I need is on WS1 in cell F8 to look at the number in cell N6
and find a match on WS 2 in column D then return the date from WS2 column A
so F8 would show 12/30/08

WS1 N
6 36441

WS2 A B C D
3 01/02/09 35486
4 12/13/08 37586
5 01/06/09 38128
6 12/30/08 36441




Don't know if it matters but WS1 cell N6 is a merged cell

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top