Vlookup

Hi Georgia

Thank you for your question and welcome to the forum.

Vlookup is a function within Excel to lookup dataup from a table of information. The table of information must have in its first column a list of unique values.

You need to enter 4 values

Lookup_Value - Value to search for in the table
Table_Array - Location of the table
Col_Index_Num - Which column number to return
Range_Lookup - Will an approximate match be okay

Example

=VLOOKUP(C2,Customers!A:D,3,False)