Formula based on vlookup. I have a workbook Sheet1 & Sheet2 Sheet2 Column A is a list of domains, some with www. others without. Each domain has a number listed against it in corresponding rows in Col B & Col C In Sheet1 I''ll be entering various domain lists, all being a subset of the full list in Sheet2. What I want to do is pull the values of each row for ColA, ColB & ColC from Sheet2 and place in the row ColA, ColC & ColD of Sheet1 against the corresponding domain eg. Sheet2 has domain on Row1 ColA http://www.domain1.com ColB 34 ColC 56 Code (markup): Sheet2 has domain sans the www.on Row 5 ColA http://domain1.com ColC ?? ColD ?? Code (markup): So the formula would match ColA Sheet2 against ColA sheet1, whether www. was in the domain or not, and replace row 5 ColA, ColC, ColD with contents of Row1 in Sheet2 i.e. Sheet 2 Row5 ColA http://www.domain.com ColC 34 ColD 56 Code (markup): If you can do this for $15 please msg me, otherwise it's off to the MrExcel forum. Thx