Not Reflecting Errors When Your Function Result Returns An Error

[KuraiChikara]

When doing a Vlookup, I was wondering how you omit or even change the result if it comes back as an #N/A error.

Example:
Sheet1 (master data)
A1-A4 has numeric values 1, 2, 3, 4
B1-B4 has items next to the values: B1=Apple, B2=Strawberry, B3=Kiwi, B4=Pie

Shee2:
This is where I want to find the ITEM from Sheet1 because Sheet2 also has numeric values in the A column but might not contain all numeric values that are in Sheet1

A column has numeric values
B column is where the formula goes =VLOOKUP(A1,Sheet1!A:B,2,FALSE)

If Sheet2 had the numeric values listed below it would return the #N/A result in B4, because my Sheet1 master doesnt have the numeric value 5.
What I want to do, is if the formula results in an error, to show it as blank or even change it to whatever text value wanted (No, Doesnt Match, Error, etc)

1	Apple
2	Strawberry
3	Kiwi
5	#N/A

 

[Michael M]

Try

=IFERROR(VLOOKUP(A1,Sheet1!A:B,2,FALSE),"",VLOOKUP(A1,Sheet1!A:B,2,FALSE))

 

[NdNoviceHlp]

=IF(ISNA(VLOOKUP(A1,Sheet1!A:B,2,FALSE)),"No Match!",VLOOKUP(A1,Sheet1!A:B,2,FALSE))

HTH. Dave

 

[Peter_SSs]

Depends on your version of Excel (perhaps you could update your profile so we know the version?) but try

=IFNA(VLOOKUP(A1,Sheet1!A:B,2,FALSE) ,"Whatever you want")