Column to vlookup [Solved/Closed]

Report
Posts
1
Registration date
Wednesday January 27, 2016
Status
Member
Last seen
January 27, 2016
-
Posts
10
Registration date
Tuesday December 1, 2015
Status
Member
Last seen
July 10, 2018
-
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 reply

Posts
10
Registration date
Tuesday December 1, 2015
Status
Member
Last seen
July 10, 2018
1
Please upload a sample for better solution.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month