Search and Retrieve

Question 1

x-lookup

Answer 1

Question 2

vlookup

Answer 2

Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID.

In its simplest form, the VLOOKUP function says:

=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).

think of this tool like a search engine

Question 3

h-lookup

Answer 3

HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find.

Question 4

match

Answer 4

MATCH(lookup_value, lookup_array, [match_type])

The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range.

Question 5

index

Answer 5

The INDEX function returns a value or the reference to a value from within a table or range.

INDEX(array, row_num, [column_num])

Question 6

differences between x and v lookup

Answer 6

XLOOKUP and VLOOKUP are both Excel functions used to search for data in a spreadsheet, but they have several key differences:
Search direction
XLOOKUP can search for values to the left and right of the lookup array, while VLOOKUP can only search to the right.
Exact match
XLOOKUP returns exact matches by default, while VLOOKUP may return approximate matches if an exact match isn’t found.
Error handling
XLOOKUP can customize text when a match isn’t found, while VLOOKUP only displays an #N/A error.
Return multiple values
XLOOKUP can return multiple values at once, while VLOOKUP can only return one value at a time.
Lookup array and return array
XLOOKUP uses a lookup array and a return array, while VLOOKUP uses a single table array and a column index number.
Search mode
XLOOKUP allows you to specify a search mode, such as starting at the top or bottom of a table, while VLOOKUP can only start at the top.

Question 7

Lookup/reference tables

Answer 7

sometimes spreadsheets don’t have a table aray that is useful and you’ll have to make table yourself for it to reference

excel tests may or may not give you these. You may have to make them yourself and format them correctly so that they don’t conflict with other parts of the sheet

Question 8

format

Answer 8

always remeber what formatting you’re in when making a spreadsheet. That will determine if your formulas work or not

Question 9

ranges

Answer 9

establish ranges for your tables so that you don’t have to worry about locking cells