Vlookup to find cell reference

[Caly]

Hi I need to see if a cell matches another cell to bring in data associated with it. I’m trying to see if column a row 1 says something to see if it is in that range of data and if yes return the associated data but if not then say no data. How can I write the formula to show that? I’m trying this but it shows #n/a if there is no match.

Column A. Column B
T-shirt. Red
Shoes. Blue

Next tab has the summary to input and I’m using the formula to enter in column B:

=if(vlookup(A2,data range from other tab $A$1:$B$2,2,0)<>A2,”No match”,
vlookup(A2,data range from other tab $A$1:$B$2,2,0)


Column A. Column B (formula)
Name. Result
T-shirt. Red
Purse. No match

 

[Alex Blakenburg]

For what you want you can use the fact that if it doesn't find it, it will return #N/A and wrap it in an IFERROR or IFNA.

=IFERROR(vlookup(A2,data range from other tab $A$1:$B$2,2,0),"No match")

 

[bebo021999]

May be:

=ifferror(vlookup(A2,data range from other tab $A$1:$B$2,2,0),"no match")

 

[AhoyNC]

With Excel 365 you could use the FILTER function.

Book2
	A	B
1	T-shirt	Red
2	Shoes	Blue
3
4
5
6	Name
7	T-shirt	Red
8	Purse	No Match
Sheet1

Cell Formulas
Range	Formula
B7:B8	B7	=FILTER($B$1:$B$2,A7=$A$1:$A$2,"No Match")