VLOOKUP with named columns, need to match the name based on first row

Hello

I have a set of data that have timestamp, temperature, and RH. Each of the temperature/RH group corresponds to a specific area, where it is labelled as "Area1". In my sampledata3 attached, this is under the tab "rawdata"

I have a series of survey respondents and I have already been able to tell that Person A sits at Area1, Person B sits at Area2, and so forth. In addition, the timestamps of the survey respondents have been rounded to the neart 15-minute timestamp, which would match my rawdata timestamp. I need to lookup the temperature/RH in the rawdata tab based on the specific timestamp of the survey responden and place it accordingly in the "timestamp_data" tab.

While it might be simple to do a VLOOKUP based on the specific column, the twist (not to sure if it is a twist) that I have is that in the "rawdata" tab, I have named the selected columns so I can get better titling and groupings (ex: Area1_temp), but I was wondering if there is a way to do a VLOOKUP based on the corresponding "title" and get the correct column. Or do I have to do some prework on the the "rawdata" tab, such as grouping the like information together.

Thanks

You can use MATCH function to identify the col_index_num for VLOOKUP function.
I assume that the area name on the first row of rawdata worksheet match with the area name in column B of timestamp_data worksheet (Area2 instead of Area2_Temp and Area3 instead of Area3_Temp). In that case, you can try below formulas.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I have not examined huuthang_bd's solution yet. I was busy working on another approach.

If I follow your intent correctly I believe HLOOKUP works also. Though your thread is marked Solved I offer this:

In C2:C5

Formula:

Please Login or Register  to view this content.

In D2:D5

Formula:

Please Login or Register  to view this content.

Edited to include upload.

Your workbook already had the Table name 'sampledata'. I used that in this formula.

I also changed "Temperature" in the timestamp_data sheet to agree with 'sampledata' headers.

Use this in C2. Fill down and across to D5. It is wildcard free and references the structured Table names.

Formula:

Please Login or Register  to view this content.

You are welcome. Glad to help. Thank you for the feedback and added rep.