paulsummersgill1

data set 58000 lines in column b, every week have to search the 58000 with 1250 references and if some kind of formula can find the reference in the 58000 in column b, i also need it to show up in column c next to it also.So if one of the references is 891245 in the 1,250 references i need some kind of formula to search through the 58,000 references in column b and when it finds it then put the same reference 891245 in column c next to it, and i need this done for all 1,250 references.
that is the issue/ problem