Vlookup if text is formatted in a certain way

I cannot figure this out. I have a LARGE spreadsheet with blanks and some junk in it. But if it has an account number I need it to pull over the value. The Account numbers are in the spreadsheet like this:
'1010-01 So they are text and I am trying to come up with a formula that if is has this account number then put a value. I came up with this Formula but some of the text I am searching in has "-" so I want it to be more specific. But I tried to use "0000-00", ####-## and neither of these worked. I am at a loss... Please help!

=IF(ISNUMBER(SEARCH("-",E11)),VLOOKUP(E11,Sheet1!A:E,4,FALSE),"")

Can you post an example workbook with all the variations that you're looking for? It's far easier to come up with a solution if we know all the variables

Here you go. It works great until you get to the bottom.

I'm guessing you want to eliminate all of the #N/A errors. Try this:

Please Login or Register  to view this content.

Does that get the results you're expecting?

I don't know why I didn't think of that... yes that works. I guess I need more coffee this morning! Thank you!

ok now is there a quick way to add the subtotals formula or will I have to do it manually?

You may be able to replace the final "" in AlKey's or my formula with your subtotals formula. There may be some additional tinkering needed, depending on the formula and how you expect it to be triggered.

Just found out there is no formulas there so I will have to manually add... oh well Thanks!