I have tried the $ correction suggested, but the problem is that the search progresses column and line past the area where the data is located. Say the data in sheet 1 is listed at A13799, and in sheet 2 that same data is located at A1650, the VLOOKUP (as it progresses from A3 down only searches accordingly on sheet 2) SO, the data I am searching for, is before where the VLOOKUP is looking at sheet 2. I need my search to be restricted to just one area, and not grow with every line in sheet 1.