VLookup with multiple matches - need to combine

Here's my dilemma - I have 2 worksheets.

One has data that needs to be normalized (4400 rows) and 40 colummns.

The second sheet has the unique rows based on a 6 column key (2700
rows).

I want to populate the remaining 34 fields on the second sheet by
retrieving the values from the first sheet- frequently, there is more
than one match in a VLOOKUP. I can do an simple COUNTIF to determine
which records will have more than one match in a vlookup.

A few columns of the data is numeric, and a simple SUMIF does the
trick there.

However, most of the columns are not numeric. For example, there are a
number of boolean (true/false) columns. In this, the logic would be if
any of the matches is true, the new value should be true. There is
also a date column, where I'd want to retrieve the most recent date.
Finally, there are some text columns, and I'd want to concatenate them
together; the order is not really relevant there.

What are my options?

Try this. It worked for me.

=IF(ISERROR(VLOOKUP(A1,Sheet2!$A$1:$B$1,2,FALSE)), VLOOKUP(A1,Sheet3!$A$1:$B$1,2,FALSE),VLOOKUP(A1,Sh eet2!$A$1:$B$1,2,FALSE))


---
Message posted from http://www.ExcelForum.com/

OOps, sorry. The reply was not intended for you.


---
Message posted from http://www.ExcelForum.com/