here is my test data;
VENDORS sheet (Columns A, b and C)
Vedor Number Vendor Name Location
1 ABC London
2 XYZ Chicago

COST EXPENDED SHEET (Col C and D only)
Vendor Name Location
ABC =IF(ISNA(VLOOKUP(CostExpended!C2,Vendors!B:C,2,FAL SE)),"Not Found",
VLOOKUP(CostExpended!C2,Vendors!B:C,2,FALSE))
TBD =IF(ISNA(VLOOKUP(CostExpended!C3,Vendors!B:C,2,FAL SE)),"Not Found",
VLOOKUP(CostExpended!C3,Vendors!B:C,2,FALSE))
XYZ =IF(ISNA(VLOOKUP(CostExpended!C4,Vendors!B:C,2,FAL SE)),"Not Found",
VLOOKUP(CostExpended!C4,Vendors!B:C,2,FALSE))


Here is the result;
Vendor Name Location
ABC London
TBD Not Found
XYZ Chicago


Since the formulae are entered in CostExpended sheet there is no need to
specify its name before C2 in the formulae

"pm" wrote:

I changed my formula as per below results are not found, but vendor names
match:
=IF(ISNA(VLOOKUP(+'COST EXPENDED'!C2,Vendors!A$2:C$320,3,FALSE)),"not
Found",(VLOOKUP('COST EXPENDED'!C2,A$2:C$320,3,FALSE)))

On vendor sheet column A is vendor number, B is vendor Name, and Column C is
Vendor Location.......

"Sheeloo" wrote:

First replace B$2:B$320 in your formula with B$2:D$320 at both places and see
if works. If not then try
(Assumption: B is the column to match on and D contains the location,
'COSTEXPENDED'!C4 contains the value to find the location for)

=IF(ISNA(VLOOKUP('COSTEXPENDED'!C4,Vendors!B:D,3,F ALSE)),"Not Found",
VLOOKUP('COSTEXPENDED'!C4,Vendors!B:D,3,FALSE))


This will give you the location if found else will say "Not Found"

In your formula

"pm" wrote:

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!