Hello
This is my data file
<tbody>
</tbody>
and in another worksheet i am using index& match formula to find detail of particular data
<tbody>
</tbody>
Here is there any formula that if i input query 1 or 2 (any1) than it shows result for rest of criteria :-
<tbody>
</tbody>
Thanks in advance
This is my data file
Stone # | Ref | Document No | Customer Ref No. | Product # | Shape Name | Report # | Seal No | Size | Pcs | Weight | Color | Clarity |
L01354 | 2217 | L01354 | Round | 1243777 | 1243777 | +1.00-1.49 | 1 | 1.02 | K | VS2 | ||
L01355 | 2217 | L01355 | Round | 1243965 | 1243965 | +0.50-0.69 | 1 | 0.50 | J | VS2 | ||
L01356 | 2217 | L01356 | Round | 1243959 | 1243959 | +0.50-0.69 | 1 | 0.50 | J | VS2 | ||
L01357 | 2217 | L01357 | Round | 1243502 | 1243502 | +0.50-0.69 | 1 | 0.50 | I | SI2 | ||
L01358 | 2217 | GL01358 | Round | 1242910 | 1242910 | +0.40-0.49 | 1 | 0.43 | I | VS2 |
<tbody>
</tbody>
and in another worksheet i am using index& match formula to find detail of particular data
Input 1 | Input 2 | Shape | Seal No | Product # | Shape2 | Color | Clarity | Size | Weight |
L01354 | 1243777 | - | - | - | - | - | - | ||
- | - | - | - | - | - |
<tbody>
</tbody>
Here is there any formula that if i input query 1 or 2 (any1) than it shows result for rest of criteria :-
Shape | Seal No | Product # | Shape2 | Color | Clarity | Size |
<tbody>
</tbody>
Thanks in advance
Last edited: