| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
(INDEX($T3:$T4849,MATCH($D3,$P$3:$P$4849),FALSE))
I have two columns, column D and P, with some overlapping values and I'm
trying to return a value from column T into a cell when the content in column D matches the content in column P. The function is working but it doesn't return the correct row from column T. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
(INDEX($T3:$T4849,MATCH($D3,$P$3:$P$4849),FALSE))
d,
You have two choices: =INDEX($T:$T,MATCH($D3,$P:$P,FALSE)) or =INDEX($T:$T,MATCH($P3,$D:$D,FALSE)) From your description, it is hard to tell which you want. HTH, Bernie MS Excel MVP " wrote in message ... I have two columns, column D and P, with some overlapping values and I'm trying to return a value from column T into a cell when the content in column D matches the content in column P. The function is working but it doesn't return the correct row from column T. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
