find name and insert address

JL · May 7, 2007

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?

Gord Dibben · May 7, 2007

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

JL · May 9, 2007

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

JL · May 9, 2007

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