title: Return rows where the columns match the colours selected EXCEL
body: <p>I'm fairly certain there's a more elegant way to do this but I can't seem to see it, or if it's staring right in front of me i'm failing to understand it.</p>
  
  <p>I have a table of data in "NEW DB" that lists numbers and blank cells in D4:W and then I have a sheet called "Colour List" where you can select the colours you want to look up, what I then want to happen in "Formulas" section in "Colour List" is to list each formula that contains those particular colours i.e Pure Black and Pure White should return Formulas 3 to 20, Pure Black and Pure Red should Return formulas 42 to 60.</p>
  
  <p>I have a feeling it has something to do with INDEX MATCH MATCH and ROWS and searching for headers but I have no idea how to get them to work as i'm always getting an #N/A error.</p>
  
  <p>It should be noted that this will extend to four searches.</p>
  
  <p>Here's a link to the file, if anyone can help I'd be grateful as it took a while to put this datasheet together</p>
  
  <p><a href="https://mega.nz/file/Oq4xHDCD#6FBZdIVk0Fn8orIiP-DJ2e-ODD_abHtO6k9WwGfJT5c" rel="nofollow noreferrer">https://mega.nz/file/Oq4xHDCD#6FBZdIVk0Fn8orIiP-DJ2e-ODD_abHtO6k9WwGfJT5c</a></p>
  
  <p>Thanks</p>