Vlookup formula to return specific text if cell contains match to list

[Apples52]

I have a list of assets in column A and a revised list of those assets in column B. In column C I want excel to return the text "Asset" if a value in column A matches a value in column B. If there's no match, leave the cell blank in column C.

I've been trying to do this with a vlookup, but can't get it to work. What formula can I use to accomplish this?

 

[awoohaw]

in C2 put this formula and copy down:

=IF(ISNUMBER(MATCH(A2,$B$2:$B$12,0)),"Asset","")

Book1
	A	B	C
1	Asset	List	Value
2	2022 F150	2022 F150	Asset
3	2022 F150 RT	2020 GMC Boxvan
4	2024 Ram 1500
5	2020 GMC Boxvan		Asset
Sheet1

Cell Formulas
Range	Formula
C2:C5	C2	=IF(ISNUMBER(MATCH(A2,$B$2:$B$12,0)),"Asset","")

 

[Apples52]

in C2 put this formula and copy down:

=IF(ISNUMBER(MATCH(A2,$B$2:$B$12,0)),"Asset","")

Book1
	A	B	C
1	Asset	List	Value
2	2022 F150	2022 F150	Asset
3	2022 F150 RT	2020 GMC Boxvan
4	2024 Ram 1500
5	2020 GMC Boxvan		Asset
Sheet1

Cell Formulas
Range	Formula
C2:C5	C2	=IF(ISNUMBER(MATCH(A2,$B$2:$B$12,0)),"Asset","")

Worked perfectly, thank you!

 

[awoohaw]

Happy to help.
Best Wishes!