If VLOOKUP can find items vertically. Then HLOOKUP can assist with finding things horizontally. I would normally use this function when building a lookup report that won't rely on columns being on the exact same place all the time. Here's something I've put together, I hope it helps!
Formula: =HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)
Lookup_value - The item you want to pull info for(single item)
Table_array - The table/area where you want to lookup from
Row_Index_Num = Count of how many rows to get from point A to point B
Range_Lookup = Choose between False(Closest Match) or True (Find closest match)
If you wish to learn more, then follow this link:
Bình luận