So , I wanted to look for the values in colomn A, if they are present in B.So the '1' in the formula represents what to print in the result. Since there is only one colomn, here it would display 'B' values. If more than one colomn is selected like =VLOOKUP(A:A,B:D,2,TRUE), in this case it will display values in second colomn 'C' and TRUE/FALSE, where FALSE would an exact match. '0' can also be used instead of FALSE.
Remove Prefix from column
=RIGHT(<field>,length)
Eg : if A1 has value ABC_12345 --> =RIGHT(A1,5) will give you 12345
Comparing values in two fields
=(EXACT(A2,B2))
Or Go to Formulas tab in excel -> Text and select Exact
Increment Values when Number Changes
=IF(A2<>A1,1,B1+1)
Click LINK
