Report

Column to vlookup [Solved]

Ask a question benhalla 1Posts Wednesday January 27, 2016Registration date January 27, 2016 Last seen - Latest answer on Jan 28, 2016 04:59PM
I am trying to write a formula that will give me the value in a cell, it needs to come from two sources. I must be able to locate the column based on a specific text, once the column is located I now need to complete a vlookup from an assigned cell to the same name in the row where we found the column with the text. a b c d e f g h
aa 1 39 40 39 23 3 25 2
bb 0 17 17 12 9 2 7 0
cc 0 0 0 0 0 0 0 0
dd 2 34 36 28 17 7 21 0
ee 7 17 24 20 9 1 8 0
FF 6 8 14 10 3 0 3 0
Results
aa
bb
cc
dd
ee
FF
I need to value from column H to be copied to the results based on the value in the 1st column and where aa=aa then return the value in h with the understanding the h can be anywhere in the worksheet.
thank you
See more 
Helpful
+1
moins plus
Please upload a sample for better solution.
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!