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
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