find name and insert address
 

In worksheet "MT" column A is the customer, column e is the ship to address
that I need. In another file, worksheet "AD" column A is the customer,
column c is the ship to address. What is the formula?

find name and insert address
 

JL

Check out VLOOKUP function.

Better yet.................

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP

On Mon, 7 May 2007 13:09:02 -0700, JL wrote:

In worksheet "MT" column A is the customer, column e is the ship to address
that I need. In another file, worksheet "AD" column A is the customer,
column c is the ship to address. What is the formula?

find name and insert address
 

Maybe I am really missing it! the formula I entered on B2 is
=IF(ISNA(MATCH(A2,'Cust Addresses'!A:A,0)),"",VLOOKUP(A2,'Cust
Addresses'!A:B,2,0))

That is what is displayed on B2. When I click on fx where it says result =
it shows the result I'm looking for. Why doesn't it display that way on B2.
Thank you,
JL

"Gord Dibben" wrote:

JL

Check out VLOOKUP function.

Better yet.................

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP

On Mon, 7 May 2007 13:09:02 -0700, JL wrote:

In worksheet "MT" column A is the customer, column e is the ship to address
that I need. In another file, worksheet "AD" column A is the customer,
column c is the ship to address. What is the formula?

find name and insert address
 

You guys are great answering simple questions. I finally found someone had
asked this question well. The answer worked for me.
It was that I had formatted the cell to be text. So I changed the format to
general, then hit F2 and enter..Voila! It's now what I need.
Thanks much!
JL

"JL" wrote:

Maybe I am really missing it! the formula I entered on B2 is
=IF(ISNA(MATCH(A2,'Cust Addresses'!A:A,0)),"",VLOOKUP(A2,'Cust
Addresses'!A:B,2,0))

That is what is displayed on B2. When I click on fx where it says result =
it shows the result I'm looking for. Why doesn't it display that way on B2.
Thank you,
JL

"Gord Dibben" wrote:

JL

Check out VLOOKUP function.

Better yet.................

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP

On Mon, 7 May 2007 13:09:02 -0700, JL wrote:

In worksheet "MT" column A is the customer, column e is the ship to address
that I need. In another file, worksheet "AD" column A is the customer,
column c is the ship to address. What is the formula?