Article Audit Assistant Interview Questions and Answers

VLOOKUP searches for a value in the first column of a table and returns a value in the same row. HLOOKUP does the same but in the first row.

• VLOOKUP searches vertically while HLOOKUP searches horizontally

• VLOOKUP requires the lookup value to be in the first column of the table while HLOOKUP requires it to be in the first row

• VLOOKUP is more commonly used than HLOOKUP

• Example: VLOOKUP can be used to find a student's grade based on their name in a table of grades

• Example: HLOOKUP ca...read more