Hi Everyone I need help on this . Thank U formula

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

@stpfool90yahoocom 

 

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

 

Maybe with this formula.