Look at Example 4:
http://www.contextures.com/xlFunctions03.html

Alternative, you could try using a Pivot Table.
http://www.contextures.com/xlPivot02.html
http://www.contextures.com/xlPivot08.html


Regards,
Ryan---

"G" wrote:

I have a worksheet of names, DOB, and address info, among other items. I've
been asked to provide this list, minus another list having lastname,
firstname and DOB, and other items not in my worksheet. I can live with
small nits. I am probably going to get this request again, or be asked to
redo it differently, so I want something that is as good as it gets with
data from different sources. I do not see how I can match three different
columns with the lookup functions.
________
Greg Stigers, MCSA
remember to vote for the answers you like