#Excel spreadsheet how to#

is the cells in which you want to search.is the value that you know and want to find a corresponding value for.Here's the syntax of the function: =HLOOKUP(,, , ) Because it's usually easiest to scan through column headings until you find the right one and use a filter to find what you're looking for, HLOOKUP is best used when you have huge spreadsheets, or if you're working with values that are organized by time. Where VLOOKUP finds corresponding values in another column, HLOOKUP finds corresponding values in a different row. Looking for a lower value, for example 88, returned an error. In the example below, a VLOOKUP looking for a score of 100 returns 90. If you enter 1 or omit this argument, the function looks for an approximate value, but we've found this to be hit-or-miss. is an optional argument, and takes 1 or 0, though you could also enter TRUE or FALSE.is the number of the column that contains the return value.When selecting your range, be sure that the first column included in your array is the one that will include your lookup value!

lets you specify the cells in which the function will look for the lookup and return values.For example, if you need to know what state a city is in, it would be the name of the city. is the piece of information that you already have.Here's the syntax of the function: =VLOOKUP(,, , ) Two examples where you might do this are (1) looking up an employee's last name by their employee number, or (2) finding a phone number by specifying the last name. The VLOOKUP function lets you find a specific value within a column and extract values from the corresponding row in adjoining columns.

#Excel spreadsheet how to#

Once you know how to search in Excel using lookup, it wonвЂ™t matter how big your spreadsheets get, you'll always be able to find what you need! We'll help you save tons of time with our list of advanced search functions. While Ctrl + F can help you find most things in a spreadsheet, you'll want to use more sophisticated tools to find and extract data based on specific values. Searching a Microsoft Excel spreadsheet may seem easy.