compare columns

  • Thread starter Thread starter rvik
  • Start date Start date
R

rvik

hi

i have two columns, col 'A' one containing my full list and the othe
col 'B' containg a partial list.. Col 'A' list contains the jobs fo
the day. Col 'B' contains the jobs completed for the day.

in the thrid column , col 'C' , i want a indication to indicate tha
the job no. in col 'A' has been completed, by comparing the data i
col 'B'

thanks a lo
 
Copy this formula down column C (change the lookup range accordingly
:-

=IF(ISERROR(VLOOKUP(A1,$B$1:$B$100,1,FALSE)),"","complete"
 
Back
Top