Hi Everyone I need help on this . Thank U formula

[stpfool90yahoocom]

SHEET 1	CORRECT ID		SHEET 2	REPLACE WITH
TASK FIND #OF INCORRECT ID's &			find INCORRECT ID	CORRECT ID
CORRECT WITH CORRECT ID
RED SHOWS RESULT NEEDED
note 2000 columns
3	C4445		4445	C4445
0	C3335		3000	C3000
	C3444		3444
1	C3000		3444
			4445	C4445
			4445	C4445

[#2]

@stpfool90yahoocom 

=IF(D8=4445,$B$8,IF(D8=3000,$B$11,""))

Maybe with this formula.