Return value from column A if match to column D

Return value from column A if match to column D

Post by VGVycm » Sun, 18 Jan 2009 02:27:02


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

Post by T. Valk » Sun, 18 Jan 2009 02:40:49

Try this:

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

Format as Date

--
Biff
Microsoft Excel MVP

 
 
 

Return value from column A if match to column D

Post by VGVycm » Sun, 18 Jan 2009 03:04:01

Perfect, thanks a bunch
 
 
 

Return value from column A if match to column D

Post by T. Valk » Sun, 18 Jan 2009 03:31:05

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP