IF or VLookup Formula to Search for a specific SKU and copy it into a different column

Hi,

I have the following list of data and want to use a formula to fill out Column B (Category) with information found in Column A (SKU), Column E (Short Codes) and Column F (Category Name).

What the formula would need to do is looking for the first 3 letters in Column (A) and based on Column E (Short Codes) add the Category Name found in Column F to the Category Column (B). There a going to be hundreds of SKU's which I need to add the Category for them.

I've tried with the =IF commands, but didn't get to far.

Does anyone have an idea on how to create a formula for my problem?

Thanks in advance.

Try this:

Please Login or Register  to view this content.

Cheers,