I am trying to use VLOOKUP to match the text in Field C with the text in Field A and then populate Field D with the values from Field B. The formula I am using is =VLOOKUP("*"&C2&"*",$A$2:$B$7,2,FALSE). The first table below is the results I would like. The second table shows the results that I am getting. Any advice would be great. Thanks.
<tbody>
</tbody>
<tbody>
</tbody>
Field A | Field B | Field C | Field D |
Paper Gasket | 1 | Yellow Paper Gasket | 1 |
Spacer | 2 | round spacer | 2 |
Paper Liner | 3 | Paper Liner Small | 3 |
Spark Plug | 4 | small pipe | 6 |
Spring | 5 | liner | 3 |
Pipe | 6 | Spring 2.5 | 5 |
<tbody>
</tbody>
Field A | Field B | Field C | Field D |
Paper Gasket | 1 | Yellow Paper Gasket | #N/A |
Spacer | 2 | round spacer | #N/A |
Paper Liner | 3 | Paper Liner Small | #N/A |
Spark Plug | 4 | small pipe | #N/A |
Spring | 5 | liner | 1 |
Pipe | 6 | Spring 2.5 | 2 |
<tbody>
</tbody>