Spreadsheet: 271493d1381952348-need-to-search-2-columns-at-once-and-report-the-results-where-matches-are-found-for-mdf
Sheet: Sheet2

 | All formula used here are array formulas, if you are changing anything in the formula, after change do not simply hit control and enter instead hold control and shift then hit enter.Once it is entered as array you can see curly braces surrounding formula which is a confirmation of array" |  |  | Managed As required BUT Results Will Be always [NAME] When [NAME] In Both i.e. I5 and J5 Both are present at the same row numbers Please let me know if You need something else |  |  |  | Search Term Below is Reffered to Palette No.  Just Enter Term Below in I5 Only | Search term below is connected to [NAME] in J5 only | Cells Contains Array Formula Here If you want to change the formula then, select the cell, press F2, Hold control and shift then Hit Enter Else formula will Return error. [NAME] Is entered till upto K40 | [NAME] Cells Contains Array Formula Here If you want to change the formula then, select the cell, press F2, Hold control and shift then Hit Enter Else formula will Return error. [NAME] Is entered till upto K40 | Both Combined in one formula Cells Contains Array Formula Here If you want to change the formula then, select the cell, press F2, Hold control and shift then Hit Enter Else formula will Return error. [NAME] Is entered till upto K40
 | apples |  |  | bananas | 77 | 2 |  | pears | oranges
 | drdrrdeyhb |  |  | hbyrhy | 77 | 2
 | rdhgeg |  |  | ftrdj | 77 | 3
 | rdhgeg |  |  | oranges | 77 | 3
 | hgrehgre |  |  | [NAME] | 77 | 5
 | jhmuhgbty |  |  | v | 77 | 6
 | hygymty |  |  | gfvgfv | 77 | 6
 | [NAME] |  |  | bg | 77 | 6
 | yb |  |  | gfbv | 77 | 6
 | dytdyt |  |  | gfbvhg | 78 | 1
 | ydt |  |  | gyii | 78 | 1
 | oranges |  |  | pears | 78 | 1
 | dy |  |  | hgbhgb | 79 | 2
 | bdy |  |  | g | 81 | 1
 | bdy |  |  | Oranges | 81 | 1
 | bdy |  |  | hgbghb | 81 | 1
 | bdy |  |  | hgb | 81 | 3
 | pears |  |  | iytki | 81 | 3
 | pears |  |  | hgb | 81 | 4
 | pears |  |  | oranges | 82 | 1
 | oranges |  |  | poranges | 82 | 1
 | bananas |  |  | gyikyi | 82 | 3
 | pears |  |  | hgbn | 82 | 3
 | bdy |  |  | h | 82 | 3
 | bdy |  |  | n | 82 | 4
 | bdy |  |  | h | 82 | 4
 | bdy |  |  | yu | 82 | 4
 | hre |  |  | bnh,myh | 83 | 5
 | dbfdb |  |  | my | 83 | 5
 | dbfdb |  |  | i | 83 | 1
 | bd |  |  | ytimktyi | 83 | 1
 | bd |  |  | ytjkyt | 83 | 2
 | bd |  |  | mi | 83 | 2
 | rdy |  |  | mi | 83 | 4
 | dryhydr |  |  | [NAME] | 84 | 6
 | pears |  |  | oranges | 85 | 1
[NAME] | Reload | into | Calvin & Florence | Spectrum | 179 | 6 | ***tt
Ellie Goulding | Burn | into | [NAME] | La La La | 180 | 1 | **tt dly
[NAME] | La La La | into | [NAME] | Applause | 180 | 1 | ***
Macklemore | Can't Hold us | into | [NAME] | Give it 2 u | 180 | 2 | ***tt
[NAME] | Give it 2 u | into | [NAME] | Summertime Sadness | 180 | 2 | ***
Dj Fresh | Hot right now | into | Drake | hold on we're going home | 180 | 2 | ***t
[NAME] | I Need your Love | into | [NAME] | Super bass | 180 | 3 | ***acca
[NAME] | Super bass | into | [NAME] | Its My party | 180 | 3 | ****
[NAME] | Its My party | into | Rizzle Kicks | Lost generation | 180 | 3 | ***
Klang | Sonnentanz | into | [NAME] | Reload | 180 | 4 | ****
Avicii | Wake Me Up | into | [NAME] | International Love | 180 | 4 | ****
[NAME] | International Love | into | [NAME] derulo | Talk Dirty | 180 | 4 | ***
MK | Look Right Through | into | Sweedish House Mafia | Miami 2 Ibiza | 180 | 6 | ***