Hi everyone,

I'm trying to get the Left function working on a vlookup and I'm not having any success. I have the following formula:

=VLOOKUP(LEFT(A3,8)+0,'...Consolidated Listing'!E$3:CG$6472,13,FALSE)

The '...Consolidated Listing is there purposely. I keep getting a #VALUE! error. Any ideas what I'm doing wrong? The value in A3 is alpha-numeric and is generated from its own Right function formula.

Thanks!!