Demosassiner
New Member
- Joined
- Aug 13, 2017
- Messages
- 7
Hi guys, hoping you can help with this. I currently have two tables, main and input/output below. I need a way to pull the "name" field that corresponds to the "main" code in the main table (which is in column D of input/output table). In other words, a formula to give me column E. Any ideas?
Main:
<tbody>
</tbody>
io (input and output, where output = main code)
<tbody>
</tbody>
Main:
Row\Col | A | B | C |
1 | Name | Code | Number |
2 | Microsoft | MSFT | 0005 |
3 | Microsoft Ltd | MICR | 0010 |
4 | Apple Inc | AAPL | 0005 |
5 | Apple (Foreign) | APLE | 0010 |
6 | Apple Co. | APCO | 0222 |
7 | FCBK | 0050 | |
8 | Facebook Corp | FBBC | 0010 |
9 | Facebook LLC | FACE | 0111 |
<tbody>
</tbody>
io (input and output, where output = main code)
Row\Col | A | B | C | D | E |
1 | Code | Name | Number | Main Code | Main Name |
2 | Micro | Microsoft Inc | 0010 | MICR | Microsoft Ltd |
3 | Apple123 | Apple | 0005 | AAPL | Apple Inc |
4 | Fbook1 | Facebook Inc | 0010 | FBBC | Facebook Corp |
<tbody>
</tbody>