View look up

Hi Nifemi

Thanks for getting in touch. A VLOOKUP is one of the most popular functions in Excel. Its most common use is to retrieve data from other Excel tables.

It looks like this:

=VLOOKUP(lookup_value, table_array, column index num, match type)

lookup_value is what you are searching for
table_array is the main source data
column index num is the column of data you're trying to retrieve
match type is whether you want an exact or not

There is a more thorough discussion of the topic in our article:

https://www.stl-training.co.uk/article-1709-use-vlookup-in-excel.html

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector