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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!