Newbie needs help....

Hi,

Have you tested the vlookup() function ?
Is it returning what you wanted ...?

Carim

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?

Well ...
There are many ways to accomplish what you are dealing with ...
A combination of index() and match() functions would also help ...

But beforehand, I would recommend you fully master vlookup() function ...

HTH
Carim