I have a very large spreadsheet with multiple sales weasels on it that
contains their gross commissions for the month. The columns a Client;
Insurance Carrier; Salesperson Class; Salesperson; Jan, Feb, March (etc for
each month that commissions are received for that client.

On another spreadsheet within the same workbook I want to just pull those
commissions received from specific clients, so that:

Bob's Auto Garage is in column A, the vlookup will also give me the amount
from column F.

The formula that I have that isn't working is:
=VLOOKUP('Com 06'!A:A="Bob's Auto Garage",'Com 06'!F:F)

The result is a #VALUE! error.

Would someone please tell me where I'm going wrong?

Thanks