pratiksuhasaria
New Member
- Joined
- Mar 26, 2019
- Messages
- 24
Hi everyone
<tbody>
</tbody>
Using Product as the key i want to extract all the datas in new table like
<tbody>
</tbody>I used formula to get Rs 50
= if("Apple" = index(A:C,MATCH("Apple",$A:$A,0),MATCH("Product",$A$1:$C$1,0),if("ABC" = index(A:C,MATCH("Apple",$A:$A,0),MATCH("wholeseller",$A$1:$C$1,0),INDEX($A$1:$C$4,MATCH("Apple",$A:$A,0),MATCH("Date",$A$1:$C$1,0)),""),"")
but when i use same formula except in place of "ABC" "XYZ" is used at XYZ column the following fuction becomes false
= if("Apple" = index(A:C,MATCH("Apple",$A:$A,0),MATCH("Product",$A$1:$C$1,0),if("XYZ" = index(A:C,MATCH("Apple",$A:$A,0),MATCH("wholeseller",$A$1:$C$1,0),INDEX($A$1:$C$4,MATCH("Apple",$A:$A,0),MATCH("Date",$A$1:$C$1,0)),""),"")
after debugging i came to know as there are two same value in product ie Apple it is considering only the first index it encounter but ignoring the rest.
But i dont want this i want each apple's index to be different.
Please Help
Product | wholeseller | price/kg |
Apple | ABC | Rs 50 |
Orange | ABC | Rs 30 |
Apple | XYZ | Rs 40 |
<tbody>
</tbody>
Using Product as the key i want to extract all the datas in new table like
Product | ABC(Price) | XYZ(Price) |
Apple | Rs 50 | 40 |
Orange | Rs 30 |
<tbody>
</tbody>
= if("Apple" = index(A:C,MATCH("Apple",$A:$A,0),MATCH("Product",$A$1:$C$1,0),if("ABC" = index(A:C,MATCH("Apple",$A:$A,0),MATCH("wholeseller",$A$1:$C$1,0),INDEX($A$1:$C$4,MATCH("Apple",$A:$A,0),MATCH("Date",$A$1:$C$1,0)),""),"")
but when i use same formula except in place of "ABC" "XYZ" is used at XYZ column the following fuction becomes false
= if("Apple" = index(A:C,MATCH("Apple",$A:$A,0),MATCH("Product",$A$1:$C$1,0),if("XYZ" = index(A:C,MATCH("Apple",$A:$A,0),MATCH("wholeseller",$A$1:$C$1,0),INDEX($A$1:$C$4,MATCH("Apple",$A:$A,0),MATCH("Date",$A$1:$C$1,0)),""),"")
after debugging i came to know as there are two same value in product ie Apple it is considering only the first index it encounter but ignoring the rest.
But i dont want this i want each apple's index to be different.
Please Help
Last edited: