Hi, I have a workbook consisting of 3 worksheets, i have to perform an exact lookup to find the codes for people on a worksheet called people.I am working on a worksheet called data,how do i achieve this, i have tried various methods each resulting in #REF
thanks
Charlie
thanks
Charlie