mdonovan890
New Member
- Joined
- Dec 22, 2016
- Messages
- 24
I am trying to generate a formula that will automatically populate the following data. I have tired various VLOOKUP, INDEX/MATCH Formula with no luck.
Here's the Data
<colgroup><col><col></colgroup><tbody>
</tbody>
When I input
<tbody>
</tbody>
I want this to come up
FRI NG CHEM RACK 08
D:10 2300120728
A:5 2300120737
B:15 2300120747
H:16 2300120749
H:14 2300120755
A:14 2300120757
A:23 2300120770
Please help!!
Here's the Data
FRI NG CHEM RACK 06 C:13 2300120694 FRI NG CHEM RACK 08 D:10 2300120728 FRI NG CHEM RACK 08 A:5 2300120737 FRI NG CHEM RACK 08 B:15 2300120747 FRI NG CHEM RACK 08 H:16 2300120749 FRI NG CHEM RACK 08 H:14 2300120755 FRI NG CHEM RACK 08 A:14 2300120757 FRI NG CHEM RACK 05 J:19 2300120759 FRI NG CHEM RACK 06 J:12 2300120769 FRI NG CHEM RACK 08 A:23 2300120770 |
<colgroup><col><col></colgroup><tbody>
</tbody>
When I input
FRI NG CHEM RACK 08 |
<tbody>
</tbody>
I want this to come up
FRI NG CHEM RACK 08
D:10 2300120728
A:5 2300120737
B:15 2300120747
H:16 2300120749
H:14 2300120755
A:14 2300120757
A:23 2300120770
Please help!!