My data is in this format in excel sheet
Sample:
Student ID 12345 59879
Class 10th 5th
Book Name Chemistry Physics
I want to lookup the above data with similar kind of format into the other sheet based on the column names which are in row wise.
Please note that below sheet has additonal row headers where the data will be taken form different source.
Student ID
Class
Book Name
How do we do that when I tried doing normal Vlook up it was showing the error in identifying the column and I understand because of the data format as column names are in row.