How to use Hlookup in MSexcel U ,you need to use function,through target selection,from menu bar to formula menu.now you have to select look up tab and reference tab access hlookup tab. then add parameter function.