Plan1
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Hi,
I put two formulas to return product name and expiration date from a list of products but there's a problem. Many products have two or more lot numbers and formula stops when first lot is found... What I want is put a lot number in cell B2 and in cells D2 and E2 to obtain product name and its expiration date.
I tried to write data another way:
Plan1
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:129px;"><col style="width:82px;"><col style="width:85px;"><col style="width:135px;"><col style="width:94px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
but it doesn't work too.
Thanks
Fabio
* | A | B | C | D | E |
1 | * | * | * | * | * |
2 | Lot Search | * | * | * | * |
3 | * | * | * | * | * |
4 | * | * | * | * | * |
5 | Product Name | Lot Nº | Exp. Date | * | * |
6 | AAAAAAAA | 123456 | 01/01/2015 | * | * |
7 | AAAAAAAA | 123568 | 01/10/2018 | * | * |
8 | BBBBBBBBB | 555444 | 15/04/2014 | * | * |
9 | BBBBBBBBB | 855443 | 15/07/2015 | * | * |
10 | BBBBBBBBB | 755855 | 16/07/2019 | * | * |
11 | BBBBBBBBB | 444552 | 20/08/2015 | * | * |
12 | BBBBBBBBB | 412144 | 18/04/2014 | * | * |
13 | * | * | * | * | * |
14 | * | * | * | * | * |
15 | NOTE 1: *in cell D2 I put *=INDEX(A6:A12;MATCH(B2;B6:B12;0)) | * | * | * | * |
16 | NOTE 2: *in cell E2 I put *=INDEX(C6:C12;MATCH(D2;C6:C12;0)) | * | * | * | * |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Hi,
I put two formulas to return product name and expiration date from a list of products but there's a problem. Many products have two or more lot numbers and formula stops when first lot is found... What I want is put a lot number in cell B2 and in cells D2 and E2 to obtain product name and its expiration date.
I tried to write data another way:
Plan1
* | A | B | C | D | E |
2 | Lot Search | * | * | * | * |
3 | * | * | * | * | * |
4 | * | * | * | * | * |
5 | Product Name | Lot Nº | Exp. Date | * | * |
6 | AAAAAAAA | 123456 | 01/01/2015 | * | * |
7 | * | 123568 | 01/10/2018 | * | * |
8 | BBBBBBBBB | 555444 | 15/04/2014 | * | * |
9 | * | 855443 | 15/07/2015 | * | * |
10 | * | 755855 | 16/07/2019 | * | * |
11 | * | 444552 | 20/08/2015 | * | * |
12 | * | 412144 | 18/04/2014 | * | * |
13 | * | * | * | * | * |
14 | * | * | * | * | * |
15 | NOTE 1: *in cell D2 I put *=INDEX(A6:A12;MATCH(B2;B6:B12;0)) | * | * | * | * |
16 | NOTE 2: *in cell E2 I put *=INDEX(C6:C12;MATCH(D2;C6:C12;0)) | * | * | * | * |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:129px;"><col style="width:82px;"><col style="width:85px;"><col style="width:135px;"><col style="width:94px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
but it doesn't work too.
Thanks
Fabio