This formula helps to pull required data from entire data. This it just reversal of vlookup. Difference between vlookup & hlookup is Vlookup pull column wise data while hlookup pulls row wise data.
=Hlookup(lookupvalue, tablerange,row index,range lookup)
No comments:
Post a Comment