Hi guys
I am after a formula be it vlookup or Match, that can give a result based on a particular word is lying in an adjacent cell. Any help would help save a lot of data input!
Eg....
Key
<tbody>
Angular
ANGL
Radius
RADI
Length
LENG
</tbody>
Data (Column 1) + Desired Result...