Hello,

What I am trying to accomplish is to be able to pull information from a worksheet by searching for a column name, and then finding a value in that column by the name of the row. When i say "name" of the column and row, i do not mean row 1-n or columns A-Z, i would like it to search by the names i assign to my data.

Ex.)


Columns A1-A8, Rows B1-B8. I want to pull the value of AxBx by searching Ax and Bx independently. I attempted this with a combination of HLOOKUP, and VLOOKUP, but got confused when it came to the indexing. If this makes any sense, any help is appreciated. If further explanation is required, feel free ask.


Thank you,
Drew