Help with search formula

fire24man Posts 1 Registration date Friday May 27, 2016 Status Member Last seen May 27, 2016 - May 27, 2016 at 03:29 PM
Need help trying to search for a specific variable, then return another variable that corresponds to the first.

I will be entering Information into columns "B", "C", "F", "G", "J".

I need a formula that searches for "K" in columns "B,C,F,G,J" and returns the values from columns "A,E,I" in column "L". I also need the same formula to search for "N" and "S". I was able to get it to work for half the spreadsheet using an IF formula, but it got to the point where the formula was to long and couldn't search all the cells needed.

Any help would be appreciated.