stuartnico
New Member
- Joined
- Jun 16, 2015
- Messages
- 10
Column A - Sheet 2 ARRAY |
1:2 |
1:4 |
1:5 |
1:6 |
1:8 |
1:10 |
1:12 |
1:20 |
etc etc |
<tbody>
</tbody>
Column A | Column B |
Tamiya 1:6 Tank | Formula search A for any in Sheet 2 list return if found = 1:6 |
Eduard 1:12 Plane | 1:12 |
Revell 1:8 Plane | 1:8 |
<tbody>
</tbody>
I suspect index and match are the way to go but no matter how I try I can't seem to work it out.