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
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 |