Hi Gebobs, all the records in sheet one are uniqe and in one colum. There are 900 records and on the second sheet there are thousamds. Just need a quick way if some looks at sheet one they click on the cell and it earches sheet two for that reocord which has other information in another colum next to it. But all the records in col b on sheet one have an exact recors in sheet two. Just thast in sheet to there are many recors of the same information if that make sense.
eg
sheet one Col B
test
test1
test2
test3
test4

sheet 2 colum b has these records but many multiples of them