If you are working in rows and want to pull information across from data that can be located either on the same sheet, different sheet or even different workbook, then we can use a HLOOKUP formula.
To create a HLOOKUP formula, click in the cell that you want to pull information to and then type =HLOOKUP( . You will then get a syntax that looks like HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]).
Lookup Value – the value you want it to look up
Table Array – the data range that you want to find the value in
Row Index Num – the row that you want to extract data from
Range Lookup – True/1 = Approximate - if it can’t find the correct lookup value it will pull across the nearest value that’s less than it.
False/0 = Exact – if it can’t find exactly what you’ve asked then it will error