Hi Mistique,

Yes, I should have mentioned adjusting the row numbers to suit your needs. Do be aware that you'll need to use the same row ranges on both parts of each formula - your 2nd & 3rd formula refer to rows 112 and 113 (presumably, the 113 should have been 112).

As for a macro solution, we would need to know whether the two files are in the same folder and, if not, what the path to the list.xls file is. The macro could be coded to apply the worksheet formulae I posted and simply insert the results into the worksheet. Do note, though, that, unlike the formula approach, the macro's results would ordinarily be static (ie they wouldn't automatically update if you changed the values in the list.xls file) or if you changed the name in the info.xls file. You could, of course, use an event-driven macro to address the latter.