Return value from column A if match to column D
 

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

Return value from column A if match to column D
 

Try this:

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

Format as Date

--
Biff
Microsoft Excel MVP


"Terri" wrote in message
...
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

Return value from column A if match to column D
 

Perfect, thanks a bunch

"T. Valko" wrote:

Try this:

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

Format as Date

--
Biff
Microsoft Excel MVP


"Terri" wrote in message
...
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

Return value from column A if match to column D
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Terri" wrote in message
...
Perfect, thanks a bunch

"T. Valko" wrote:

Try this:

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

Format as Date

--
Biff
Microsoft Excel MVP


"Terri" wrote in message
...
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