ExcelBanter - (INDEX($T3:$T4849,MATCH($D3,$P$3:$P$4849),FALSE))

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - (INDEX($T3:$T4849,MATCH($D3,$P$3:$P$4849),FALSE)) (https://www.excelbanter.com/excel-worksheet-functions/126538-index-%24t3-%24t4849-match-%24d3-%24p%243-%24p%244849-false.html)

[email protected]

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

Bernie Deitrick

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

All times are GMT +1. The time now is 02:09 AM.