There is no limitation of using those two functions but it is time consuming for large datasets. Instead of this two functions we can use index and match functions to extract in both format horizontal and vertical.
V and Hlookup is important functions in Excel
used when you have tracker sheet and someone ask you to check or fill some information from your tracker you can used vertical or horizantal lookup that depends in your tracker cells to give the informtion in very short time and100% accurate