track number between two tabs on same workbook

[ThierryR]

I'm trying to see if the same numbers exists in two different spreasheets on the same workbook. Both "asset tags" columns are sorted ascending. If the number appears on both table I would like my formula to add a "Y" (for yes) on the proper cell. Not sure if I should use Vlookup, sumproduct or sumif formula. Here is the main table where I want that "Y" to appear in Column D.
Thanks for any help
Thierry

Fixed Asset FAP.xls
	A	B	C	D
1	ASSETTag	Check?	DESCRIPTION	MajorEquipment
2	09436		SHAPERDELTAWOOD
3	011990		KEYCABDELUXEFLOORTYPE
4	013075		TALLESCOPE19FT
5	039218		TRACTOR51FORD8N409655W/ACC
6	047289	X	TRUCKLIFTELECTW125-90-2139
7	047290		CHARGERBATTERYB-30485
8	048187		SAWPOWERMATIC10INSN066596
9	048384		LATHE13X48SNB10729USED
Sort by - Asset Tag

 

[ThierryR]

Okay try this in the sheet where you want the X's. Adjust your ranges to match your sheet.

=IF(ISNUMBER(INDEX($A$1:$A$8,MATCH(A1,Sheet1!$A$1:$A$8,0))),"X","")

Also, instead of entering the first X manually why don't you use

=IF(D1="Y","X","")

For the "IF" formula I can not use it because I manually enter the "X" when i physically see the Asset on the field (the "Y" sign meant that this Asset is a Major Asset instead of a Minor asset)

For the "ISNUMBER" I'm going to give it a try now.
Thanks again for your help
Thierry