troubleshooting Question

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

Avatar of vijay vj
vijay vjFlag for India asked on
Microsoft ExcelMicrosoft Office
2 Comments1 Solution107 ViewsLast Modified:
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
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros