Combining data from 2 spreadsheeets to 1

Anyone got any suggestions how to combine data from 2 spreadsheets where some info is shared and potentially some duplicated.

Example first file has columns headed Client Name, Client Number
Second file has columns headed Client Name, Client Value.

Problem is second file doesnt include all Client Names in it and corresponding client values.

What I would like is 1 combined file of Client Name, Client Number, and Client Value.

Any suggestions greatly appreciated.

Hi hoooray,

You can use Vlookup for a simple consolidation..

Vlookup - "Searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data you want to find.

The V in VLOOKUP stands for "Vertical."

Syntax

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)"

I have attached a sample file for your reference.

HTH,
Vaibhav