How does VLOOKUP work?

Hi Evanthia,

Thank you for your feedback and welcome to the forum.

The Vlookup formula has four arguments:
(Lookup_Value,Table_array,Column_Index_Number,Range_Lookup)

The function is used to search for a value entered into a cell, search for that value in the first column of your database(Table_Array) and return the value from a column you specify in the same row.

Please find the link below:

http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel

This is a working example. I have also attached an example spreadsheet with an example.

I hope this helps you.

Regards

Simon