This is a simple tutorial in just one of many easily overlooked Microsoft Excel functions. If you find lots of gaps like these in your Excel knowledge then one of our tailor-made Excel training courses will be just what you need. We have public courses in Beginners Excel Training and Advanced Excel Training, and we can also tailor a private course to suit the individual need of you or your business.
VLOOKUP and HLOOKUP allow you to search a data range for any value entered, and return information or a value based on that data. VLOOKUP allows you to search information formatted by column, HLOOKUP for information formatted by row.
Read the rest of “Excel Tutorial – How to Use the VLOOKUP and HLOOKUP functions”

After the popularity of our previous