Explanation of Lookup function and vector form with table as a range

I would like someone to explain the Lookup function in a more dumbed down version than they have elsewhere.

Then explain the difference between the Vector Form and the array.

Then explain what the gmetrix Excel 2013 expert practice test is asking me and why the solution is what it is. Part of my confusion is that the vector range is a whole table, and the vector result is only one column. And I thought the two had to be the same size.

Thanks you.

Maybe take me step by step through it and see if I understand that part before moving on to the next.

How are we supposed to know what the Excel 2013 expert practice test is asking you?

You really need to much more specific: what is it about the LOOKUP function that you don't get?

I'd like to be able to help, but you haven't been specific enough. Please answer the question I asked.

Show us the formulae, preferably in a sample sheet and there will be plently of helpers.

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

But you haven’t told us what you find unclear about the explanations you have already found, so it’s impossible to know what it is you want clearing up. As far as I am concerned, all the explanations I have found online are clear, so what is it you are having difficulties with?