Here's something simple I've put together that I hope you'd be able to follow.
Formula: =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
Lookup_value - The item you want to pull info for(single item)
Table_array - The area where you want to lookup from (Must begin where the common value is located. Point A is the beginning, Point B is where the information you want to pull is located
Col_Index_Num = Count of how many columns in between point A to point B
Range_Lookup = Choose between False(Closest Match) or True (Find closest match)
Caveat: This function will only pull the FIRST data. So if you have multiple items, you will need to first figure out to remove duplicates or sort the items ascending/descending.
You can see more examples and video from this link:
留言