S
shnim1
Hi
I have data in four columns. Column A have numbers in the cell
(numbers between 1-20), column B with numbers 1-5, colum C with number
1-6. These numbers are not in any kind of order and sometimes repea
themselves (shown more than once). In colum D I have text in each cell
What I need to do is to extract the line of text that corresponds to
row that meets a number criteria.
For example:
I get numbers 16, 4, and 2 (colums A. B and C). I need to know what th
text is in column D that has these three numbers in its row. I hav
tried:
=sumproduct(--(a1:a20=16),--(b1:b20=4),--(c1:c20=2),(d1:d20))
but that just wants to add the cell value in coilumn D and return
value of zero
please can anyone help
Cheers in advanc
I have data in four columns. Column A have numbers in the cell
(numbers between 1-20), column B with numbers 1-5, colum C with number
1-6. These numbers are not in any kind of order and sometimes repea
themselves (shown more than once). In colum D I have text in each cell
What I need to do is to extract the line of text that corresponds to
row that meets a number criteria.
For example:
I get numbers 16, 4, and 2 (colums A. B and C). I need to know what th
text is in column D that has these three numbers in its row. I hav
tried:
=sumproduct(--(a1:a20=16),--(b1:b20=4),--(c1:c20=2),(d1:d20))
but that just wants to add the cell value in coilumn D and return
value of zero
please can anyone help
Cheers in advanc