Hi,

i've had a quick play about with vlookup(), but it seemed to me i'd have to do a lot of manual searching, and would have to input an appropriate formula in each cell?

i think there is more i can do with vlookup() with a bit of time, but was wondering if there was any other ways of getting the result. Ideally i'm trying to have a spreadsheet set up that i can put in the two lists and it will automatically do a search and give the analysis i'm after. is this a bit of wishful thinking?