Spreadsheet: 271395d1381927403-need-to-search-2-columns-at-once-and-report-the-results-where-matches-are-found-test
Sheet: Sheet1

 | 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" |  |  |  |  |  |  | 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 | ***