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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
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 |