Vlookup

Hello Susan

Thank you for your question and welcome to the forum.

The VLOOKUP function is used to extract a certain piece of data from a list.

The function asks Excel to look for a particular item (the lookup value) through the leftmost column of a table, and then extract a piece of information in the same row, from a different column.

The function syntax is as follows:
=VLOOKUP(lookup value,table array,column index number,range)

The lookup value is the item you are getting Excel to look for in the leftmost column of the table array.

The column index number is the number of the column that you want Excel to extract the corresponding piece of data from. Each column in the table array is allocated a number, starting from 1 being allocated to the leftmost column and each of the following columns being numbered consecutively.

The range refers to if you need an exact or approximate match to the lookup value you specify. If you require an exact match enter false; if you require an approximate match ('near enough is good enough'), enter true or leave the range part of the function blank.

I hope this helps.
Amanda