In this tutorial we will look at the VLOOKUP Excel Assessment Test Question asked as part of the consulting interview. A lot of time consulting companies test candidates based on the real assignments that they had to complete and use Microsoft Excel Application, instead of using test format or simulator questions. Companies might also share with you workbooks with large sets of data 100K_ rows which wouldn't be perfectly formatted to simulate real working conditions.

Question. Client is looking for a number of items that have been sold in the set of data. Client only remembers that Transaction ID contained the value 0330, somewhere in transaction ID field
How can you help client to find number of items sold for this transaction id using VLOOKUP formula?

We will also look at how to solve Variation of this Question: Client only remembers that Transaction ID contained the value from cell F3, somewhere in transaction ID. How can you help client to find number of items sold for this transaction id using VLOOKUP formula?

The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. But you can't use Exact match or Approximate Match? How can you use VLOOKUP to solve the business challenge in Excel Assessment Test in Consulting Interview?

Video Tutorial

XLSX Files Download

There are 2 Excel Assessment work files included in this free download. Complete the  form below and you will be redirected to the download page.

• Consulting Interview Preparation - Advanced Excel VLOOKUP Test.xlsx - XLSX Source File
• Consulting Interview Preparation - Advanced Excel VLOOKUP Test.xlsx.zip - XLSX Source file in Zip Archive