How to Calculate a Vlookup on Excel for Loans. In Excel a "Vlookup," short for vertical lookup, is a formula used to return a value from a table of data. For example, you might want to add a ...

Excel's VLOOKUP function searches cell arrays for data that you provide. The function often takes cell references as input, letting you easily apply the function to each cell in a range.