Avatar of vijay vj
vijay vj
Flag for India asked on

how to return set of columns values with one column header name lookup

Dear sir, i have set of values in column A,B and so on each column has header name and their values are below the header name row for (e.g) 1 to 10 rows have values 1 to 10. and below that row another column header name with 1 to 10 values below that row and so on, is it possible to get that set of 1 to 10 values with looking up of column names. i have attached the excel sheet , where sheet 2 has values and in sheet 3 ,i have highlighted what i need to do so, thanks
New-Microsoft-Excel-Worksheet.xlsx
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
vijay vj

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
byundt

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
vijay vj

ASKER
thanks sir
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck