I don't think there is an existing function for this. You would almost definately have to write a macro to do this. If you post either the sheet or a more detailed description of your problem, we could help better.
I won't be able to use the color HTML maker to post the sheet (I can email it). I wish I could. I would like to compare a name(or key field) that is in book2 with a name or (key field) in book 3>> Get data for a column and place it in book 3. DOUNTIL all names (or key field is empty).
Here is a macro that I started. There is no repect to a key field and it doesn't DO_UNTIL.