I have a spreadsheet with two sheets - a vendor sheet, listing the vendor
number, name and location, and a cost expended sheet including date, vendor
name, dollar amt, etc. I've created a vlookup formula to match the vendor
names from both sheets and give me the location in column 3 on the vendor
sheet, but I'm not getting the results I expect #N/A. Here's my formula:

=IF(VLOOKUP(+'COST
EXPENDED'!C4,Vendors!B$2:B$320,3,FALSE)=0,"",(VLOO KUP('COST
EXPENDED'!C4,B$2:B$320,3,FALSE)))

Thanks for your help!