Hi All,

Average Excel user at best and wonder if someone can help!

What I'm trying to do is:

I have a download from an accounting software in Excel and I'm trying to do a lookup but instead of =vlookup(A1,'filename'!$A:$Z,2,false) I want it to work if A1 appears in the first 8 character of 'filname'!$A:$Z,2,false. (A1 is 123 lookup file cell is 123 abcdef)
Does that make sense or can it be done?

Thanks