I have a vertical list of names (25) in column A (all distinct and different). In column B through F, I have numeric values. In Row H, there are a list of names only (say 150).
I want to look up the corresponding name in Row H, and auto fill the information from rows B through F, in rows I through M.
I am looking for the HLOOKUP formula to accomplish this task.
Any help would be greatly appreciated.