Okay, I finally broke down after reviewing all possible threads on this forum and a few other forums over the weekend. I have attached a small file for clarification. First, I would like to have all the results that meet the match criteria to be returned across columns instead of down rows. I have a formula that works except 1. it only pulls the first matching event and not subsequent events and 2. it only works if I copy the formula down the rows but not across columns. For instance, at D13/E13, I would expect to see the results as in F13/G13. At D14/E14 I would expect results as in F14/G14 and so on. I know there are duplicates in the B/C columns but I ma not too concerned with that. My main concern is the resulting return of information based on the match criteria. So although B/C 13 is the same as B/C 16 tha's not a problem. At first i thought the duplicates in B/C were causing the conflict bu even after I eliminated the duplicates in those columns, the formula did not work as expected. I have tried tweaking the formula I used in column D bu no joy. There are also 2 other formulas at the bottom on lines 29 and 30 that I have used with limited success. Again, copying the formula down gives me a result of the first instance only and not the subsequent finds. I am trying to stay away from a "helper" because my original data is massive. Any assistance would be greatly appreciated as I have beat my head against the wall on this for several days. Thanks in advance...Al
Bookmarks