Vlookup

So if you look at the attached sheet, I want to make some kind of VLOOKUP formula or any formula what would enter the correct category/sub category on the DATA sheet based on if the contents the the description "contain" data in the description column on AutoCat sheet....for example on line 15 on the DATA sheet, it says "BLUE RIDGE COMM CABLE BILL ***********2001" and on the AutoCat Sheet on line 3 it just says Blue Ridge, how could I make the category and sub category automatically fill in on the DATA sheet based on the data in the Auto Cat sheet?

If you do not have duplicates in the worksheet 'data' in column C, use the following formulas
Formula in D4 cell, copy down
Formula in E4 cell, copy down

navic said:

If you do not have duplicates in the worksheet 'data' in column C, use the following formulas
Formula in D4 cell, copy down

Code:

=VLOOKUP([@Description];T_Auto_Cat;2;FALSE)

Formula in E4 cell, copy down

Code:

=VLOOKUP([@Description];T_Auto_Cat;3;FALSE)

Click to expand...

I keep getting the "there is a problem with your formula" popup, I thought it was because of the ; in stead of a , so changed it to a , and then I got #N/A in every column except if it was an exact match

My apology, I did not read the question properly.
Try the following ARRAY formula
In D4 cell try (copy across D and E column)

AWESOME! Thank you so much, that works perfectly!

You're welcome
On this link also, you have the tutorial for the reverse situation.

- Return the data if the word with the sentence text matches