Question about Business & Productivity Software
PLEASE EXPLAIN ME HLOOKUP FORMULA IN MS EXCEL.
Lookup value = value searched
table array = database
topmost row of lookup array must contain the data IDs and all IDs must be sorted in ascending order.
row index number = row number containing data to be shown; first row = 1
hlookup(x,tablearray,y) will look for x on the first row of the lookup table and return the value in the cell on the yth row
if formula cannot file exact x, it will look for the value closest to. but not greater than x
Posted on Nov 18, 2008
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Mar 14, 2011 | Microsoft Excel for PC
Feb 03, 2009 | Microsoft Excel for PC
Dec 02, 2008 | Microsoft Excel for PC
Nov 13, 2008 | Business & Productivity Software
Aug 25, 2008 | Microsoft Office Professional 2007:...
Jul 17, 2008 | Microsoft Office Professional 2007 Full...
Nov 24, 2007 | Business & Productivity Software
Jan 16, 2017 | The Business & Productivity Software
319 people viewed this question
Usually answered in minutes!