VLOOKUP to Return whole Vertical row values in vba

[jeyachandran]

Hi sir,
I need an Macro function for VLOOKUP to Return whole Vertical row values. ie when Select Drop Down list in Sheet (Source) in Noun-Modifier column, then
Sheet (Template) Value automatically populated as per example (Data) attached in sample file. Could you resolve my query.

Note:
Sheet (Source) is input
Sheet (Data) is Output
Sheet (Noun Modifier Unique) is for Data Validation (List)

 

[Marc L]

Hi, should be achieved with an Excel basics like an advanced filter for example like any Excel beginner can operate …​

… but if really a code is necessary as your attachment can not contain any code so where should be located the VBA procedure ?​

​

Should be less confusing for any helper if the attachment expected result matches the explanation ‼​

​

 

[jeyachandran]

Hi sir,
According to my last post "https://chandoo.org/forum/threads/v...orizontal-row-values-in-vba.48306/post-286022"
the procedure says, when select select drop down list from Noun Modifier column, the catted value automatically filled horizontally as per Vba
UDF Funtion and formula used, that the same thing to be applied in this Sample Sheet but in vertical format.

Note:
1. Sheet (Source) ie input file. if i choose Noun modifier in column C, The Sheet Template, ie Catted Value to be Populated as Per Sheet (Data).

I think its clear to understand my Need..

Thanks

 

[Marc L]

« No arm, no chocolate ! »
As my question is enough clear to receive at least an answer ...​

​