Column to vlookup

Solved/Closed
benhalla Posts 1 Registration date Wednesday January 27, 2016 Status Member Last seen January 27, 2016 - Jan 27, 2016 at 03:33 PM
NickBR Posts 7 Registration date Tuesday December 1, 2015 Status Member Last seen July 10, 2018 - 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

1 response

NickBR Posts 7 Registration date Tuesday December 1, 2015 Status Member Last seen July 10, 2018 1
Jan 28, 2016 at 04:59 PM
Please upload a sample for better solution.
1