Column to vlookup [Solved/Closed]

benhalla 1 Posts Wednesday January 27, 2016Registration date January 27, 2016 Last seen - Jan 27, 2016 at 03:33 PM - Latest reply: NickBR 10 Posts Tuesday December 1, 2015Registration date July 10, 2018 Last seen
- Jan 28, 2016 at 04:59 PM
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 

1 reply

Best answer
NickBR 10 Posts Tuesday December 1, 2015Registration date July 10, 2018 Last seen - Jan 28, 2016 at 04:59 PM
1
Thank you
Please upload a sample for better solution.

Thank you, NickBR 1

Something to say? Add comment

CCM has helped 1881 users this month