title: Google Sheets Indexing and Matching issue
body: <p><a href="https://i.stack.imgur.com/2yjIA.jpg" rel="nofollow noreferrer">CleanedData tab</a>  <a href="https://i.stack.imgur.com/03oFS.jpg" rel="nofollow noreferrer">RawData tab</a> I am tracking clients in google sheets with 2 different tabs, RawData and CleanedData.</p>
  <p>Both tabs have 11 different columns, one being a &quot;purchase date&quot; column</p>
  <p>The RawData tab keeps track of all clients that have signed up for info sessions regardless if they made a purchase or not, so every time a client has made a purchase it populates another row with the date of purchase.</p>
  <p>In the cleaneddata tab I want to clean all the data from the RawData tab into one row for each client, for example if client &quot;X&quot; has 5 rows of data in the RawData tab but only one of those rows has his purchase date, I then want to pull that row with the purchase date into the cleaneddata tab.</p>
  <p>The issue I'm having is that the purchase date is not copying over to the cleaneddata tab and I believe it is because it's accounting for the duplicate data rows that are in the RawData tab, that I need to be there.</p>
  <p>The equation I'm using in the purchase date cell of the cleaneddata tab is:
  =index(RawData!$A$1:$L, match(1,($A428=RawData!$A$1:$A)*($L428=RawData!$L$1:$L),0),match(J$1,RawData!$A$1:$L$1,0))</p>
  <p>Is there anyway to rework this equation to account for the duplicates in the RawData tab so that the purchase data will copy over?</p>
  <p>Any help is greatly appreciated,</p>
  <p>Thank you</p>
  <p>Edit: I can not share the sheet file for security purposes but I uploaded a picture of what the RawData and CleanedData tabs look like, I need some equation or method to pull the purchase date from the RawData tab to the cleaneddata tab that also accounts for the repeated rows in the RawData tab</p>