Excel formula

[Ktripat1]

Hello guys,

In the sheet attached, I am trying to match row "14" with row "9", if it is "L3" and automatically come in Vertical format in the next tab without filtering it everytime. can someone help me with this.

Thanks!

[shukla.ankur281190]

Try

F14

Please Login or Register  to view this content.

Drag towards the cells.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

[Ktripat1]

Hi Ankur,

Thanks for your help, but I want to drag the values from "vector" sheet in input sheet. So, I am trying to match 10 digit codes in row 14 against row 9 if "l3" and then instead of horizontal layout I want it in vertical format in Input sheet.

Like this below and all of these are "L3"

L025809BHP_X
L025809BHP_Y
L025810ACE_X
L025810ACE_Y
L025810ACE_Z
L025810BCE_X
L025810BCE_Y
L025810BCE_Z
L025810CCE_X
L025810CCE_Y
L025810CCE_Z
L025810DCE_X
L025810DCE_Y
L025810DCE_Z
L025810FCE_Z
L025810GCE_Z
L025810HCE_Z
L025810ICE_Z
L025888ALS_X
L02A983AHE_X
L02A983AHE_Y
L02A983AHE_Z
L085809AAZ_Z
L1A5809AAZ_Z
L1A5809BHP_X
L1A5809BHP_Y
L1A5810ACE_X
L1A5810ACE_Y
L1A5810ACE_Z
L1A5810BCE_X
L1A5810BCE_Y
L1A5810BCE_Z
L1A5810CCE_X
L1A5810CCE_Y
L1A5810CCE_Z
L1A5810DCE_X
L1A5810DCE_Y
L1A5810DCE_Z
L1A5810FCE_Z
L1A5810GCE_Z
L1A5810HCE_Z
L1A5810ICE_Z
L1A5888ALS_X
L1AA983AHE_X
L1AA983AHE_Y
L1AA983AHE_Z
R025809BHP_X
R025809BHP_Y
R025810ACE_X
R025810ACE_Y
R025810ACE_Z
R025810BCE_X
R025810BCE_Y
R025810BCE_Z
R025810CCE_X
R025810CCE_Y
R025810CCE_Z
R025810DCE_X
R025810DCE_Y
R025810DCE_Z
R025810FCE_Z
R025810GCE_Z
R025810HCE_Z
R025810ICE_Z
R025888AHE_X
R025888AHE_Y
R02A983AHE_X
R02A983AHE_Y
R02A983AHE_Z
R085809AAZ_Z
R1A5809AAZ_Z
R1A5809BHP_X
R1A5809BHP_Y
R1A5810ACE_X
R1A5810ACE_Y
R1A5810ACE_Z
R1A5810BCE_X
R1A5810BCE_Y
R1A5810BCE_Z
R1A5810CCE_X
R1A5810CCE_Y
R1A5810CCE_Z
R1A5810DCE_X
R1A5810DCE_Y
R1A5810DCE_Z
R1A5810FCE_Z
R1A5810GCE_Z
R1A5810HCE_Z
R1A5810ICE_Z
R1A5888AHE_X
R1A5888AHE_Y
R1AA983AHE_X
R1AA983AHE_Y
R1AA983AHE_Z

[Ktripat1]

Hi Ankur,

Thanks for your help, but I want to drag the values from "vector" sheet in input sheet. So, I am trying to match 10 digit codes in row 14 against row 9 if "l3" and then instead of horizontal layout I want it in vertical format in Input sheet.

Like this below and all of these are "L3"

L025809BHP_X
L025809BHP_Y
L025810ACE_X
L025810ACE_Y
L025810ACE_Z
L025810BCE_X
L025810BCE_Y
L025810BCE_Z
L025810CCE_X
L025810CCE_Y
L025810CCE_Z
L025810DCE_X
L025810DCE_Y
L025810DCE_Z
L025810FCE_Z
L025810GCE_Z
L025810HCE_Z
L025810ICE_Z
L025888ALS_X
L02A983AHE_X
L02A983AHE_Y
L02A983AHE_Z
L085809AAZ_Z
L1A5809AAZ_Z
L1A5809BHP_X
L1A5809BHP_Y
L1A5810ACE_X
L1A5810ACE_Y
L1A5810ACE_Z
L1A5810BCE_X
L1A5810BCE_Y
L1A5810BCE_Z
L1A5810CCE_X
L1A5810CCE_Y
L1A5810CCE_Z
L1A5810DCE_X
L1A5810DCE_Y
L1A5810DCE_Z
L1A5810FCE_Z
L1A5810GCE_Z
L1A5810HCE_Z
L1A5810ICE_Z
L1A5888ALS_X
L1AA983AHE_X
L1AA983AHE_Y
L1AA983AHE_Z
R025809BHP_X
R025809BHP_Y
R025810ACE_X
R025810ACE_Y
R025810ACE_Z
R025810BCE_X
R025810BCE_Y
R025810BCE_Z
R025810CCE_X
R025810CCE_Y
R025810CCE_Z
R025810DCE_X
R025810DCE_Y
R025810DCE_Z
R025810FCE_Z
R025810GCE_Z
R025810HCE_Z
R025810ICE_Z
R025888AHE_X
R025888AHE_Y
R02A983AHE_X
R02A983AHE_Y
R02A983AHE_Z
R085809AAZ_Z
R1A5809AAZ_Z
R1A5809BHP_X
R1A5809BHP_Y
R1A5810ACE_X
R1A5810ACE_Y
R1A5810ACE_Z
R1A5810BCE_X
R1A5810BCE_Y
R1A5810BCE_Z
R1A5810CCE_X
R1A5810CCE_Y
R1A5810CCE_Z
R1A5810DCE_X
R1A5810DCE_Y
R1A5810DCE_Z
R1A5810FCE_Z
R1A5810GCE_Z
R1A5810HCE_Z
R1A5810ICE_Z
R1A5888AHE_X
R1A5888AHE_Y
R1AA983AHE_X
R1AA983AHE_Y
R1AA983AHE_Z

[Sam Capricci]

Hey Ktripat1, welcome to the forum but please take a minute to read the forum rules and change your post title to something more appropriate to the problem. Think in terms of search, how would someone with the same problem find your post and solution with a title like that?
This post should not receive any more replies until the post title is changed.
thanks.

[FDibbins]

Ktripat1 welcome to the forum

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 )