Return value from column A if match to column D

[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

 

[T. Valko]

Try this:

=INDEX(WS2!A3:A6,MATCH(N6,WS2!D36,0))

Format as Date

 

[Terri]

Perfect, thanks a bunch

Try this:

=INDEX(WS2!A3:A6,MATCH(N6,WS2!D36,0))

Format as Date

 

[T. Valko]

You're welcome. Thanks for the feedback!