Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match values in two column and return value in | Excel Worksheet Functions | |||
Search, Match, And return corresponding column value | Excel Worksheet Functions | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
Match a cell to something in a column and return a YES | Excel Worksheet Functions | |||
Index? Match? Function to sort and return value fr diff column in | Excel Worksheet Functions |