please see attached spreadsheet.
column A is a list of numbers, a handful which contain letters.
the first formula is to simply remove all letters from every row in this column leaving all numbers. example if there is a 2226A that needs to be 2226.
2nd formula:
comparing columns A and B looking for matches.
each row in A needs to search all of column B for a match and if there is a match, output the number 5 into column C. if no match output 0 in column C.
see attached spreadsheet with a few example outputs.
note column A has many repeats of the same number.
if this goes well, i will have a follow up job using the formulas.
rows A and B come from 2 different spreadsheets which change everyday (inventory).
will need to use the new formulas to create a single or 2 step process to update within the whole sheets.