Which formula?
 

Hi,
I have a spreadsheet with all the clients sales and one of the columns is
the country of the client (which is empty).
On another sheet I have all the contact info with the country.
I need a formula to put the client country from the contact info to the
client sales!
In both sheets I have the client number.

any suggestion?
Thanks,
Barbara

Which formula?
 

Let's assume the client # is in column A on both the sheet with the sales and
the contact info sheet. Let's also assume that the country is in column F in
the contact info sheet.

First thing: select all the data on the contract info sheet and name that
range Contacts

In the first row where you want to put the country (let's say it's row 2),
use this formula

=vlookup(a2, Contacts, 6,false)

This function tells Excel to take the client # in cell A2, find it in the
first column of the Contacts range, and bring back the value in the 6th
column of that range. The false argument means you want an error message if
the client# can't be found.



"Barbara" wrote:

Hi,
I have a spreadsheet with all the clients sales and one of the columns is
the country of the client (which is empty).
On another sheet I have all the contact info with the country.
I need a formula to put the client country from the contact info to the
client sales!
In both sheets I have the client number.

any suggestion?
Thanks,
Barbara

Which formula?
 

Thank you very much. Finally someone explains the function suggested.

Great.

"Duke Carey" escreveu:

Let's assume the client # is in column A on both the sheet with the sales and
the contact info sheet. Let's also assume that the country is in column F in
the contact info sheet.

First thing: select all the data on the contract info sheet and name that
range Contacts

In the first row where you want to put the country (let's say it's row 2),
use this formula

=vlookup(a2, Contacts, 6,false)

This function tells Excel to take the client # in cell A2, find it in the
first column of the Contacts range, and bring back the value in the 6th
column of that range. The false argument means you want an error message if
the client# can't be found.



"Barbara" wrote:

Hi,
I have a spreadsheet with all the clients sales and one of the columns is
the country of the client (which is empty).
On another sheet I have all the contact info with the country.
I need a formula to put the client country from the contact info to the
client sales!
In both sheets I have the client number.

any suggestion?
Thanks,
Barbara