Simple Lookup has me stumped

[aplnub]

I have columns of data. Each column has a title. A, B, C, etc. I want extract the corresponding row item from Column C. I have attached a link to a spreasheet setup to show what I am trying to do. It will clear up my inadequate description.

I was going to use HLookup but if I copy it down the page it doesn't work. I have to specify a specific row for it to pull from.

Any help would be great. This seems too easy for my monkey brain not to figure out and I am stumped.

https://www.dropbox.com/s/gx7sr5z74ab7rlo/Simple Lookup.xlsx?dl=0

 

[Special-K99]

in H6
=C6
and copy down column H.

 

[Fluff]

Or is this what you mean
=IFERROR(INDEX($H$6:$H$14,MATCH(LEFT(A6,LEN(A6)-1)*1,$F$6:$F$14,0)),"")
In B6 copied down

 

[aplnub]

Thank you for the responses. I have updated the spreadsheet and will give a little bit more detail. I want to pull data from the column stated in cell B5. I want to be able to change that to A, B, C, D, etc.

 

[Fluff]

How about
=INDEX($F$6:$I$15,ROW($A1),MATCH($B$5,$F$3:$I$3,0))

 

[aplnub]

How about
=INDEX($F$6:$I$15,ROW($A1),MATCH($B$5,$F$3:$I$3,0))

That did it. Thank you. Now I need to study how it works. Many thanks!!

 

[Fluff]

You're welcome & thanks for the feedback

 

[michaeltsmith93]

That did it. Thank you. Now I need to study how it works. Many thanks!!

Google "index match," and go to the first link. It's an exceljet link.