The VLOOKUP function supports wildcards which makes it possible to perform a partial match on a lookup value. This method requires a little preparation but in the end you will have a more compact formula to Vlookup in any number of spreadsheets. How to use the VLOOKUP function in Excel The Excel VLOOKUP function searches and returns data from a table vertical orientation.
In this example you will see how to use two or more table arrays in the Excel.
It is used as the database function to perform calculations on the tables imported from the database. If you have rows of data organized by column headings VLOOKUP can be used to locate a value using the column. Enter the table array of the spreadsheet where your desired data is located. To use wildcards with VLOOKUP you must specify exact match mode by providing FALSE or 0 for the last argument range_lookup.