Index and match horizontally from one sheet and result vertically to other sheet!

Hi Guys,

I want all 10 digit code starting from "f14:fO14" MATCH it against row 11 which is equals to "L3" and then output in "Input sheet" vertically.

Please see the sheet attached.

In a2, copied down:

=IFERROR(INDEX(Vector!$14:$14,AGGREGATE(15,6,COLUMN(Vector!$F$14:$FO$14)/(Vector!$F$11:$FO$11="L3"),ROWS($1:1))),"")

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.