Cell A1 contains Long Text and another Cell A2 gives small text

If A1 is "Cross-national and global-regional strategy formulation. Determining of overall multi-national organisations strategy and direction. Decides the “what” jointly with the board. Board influences the strategy. Turnover usually bigger than $1bn. Income mostly from 1 country." then A2 is "G1"; and if A1 is "Cross-national and global multinational strategy formulation and direction. Decides the “what” jointly with the board. Board influences the strategy. Turnover usually over $4bn. Income mostly from a few countries." then A2 is "G1"; and ...."G6"

I do have specific VLOOKUP formula I can use?

I have formula correct but it gives "#N/A" errors