Excel Searching...

[dodgyone]

I have a main Excel file which lists codes and addresses. I would like to be able to link into that spreadsheet from another Excel spreadheet, search down the lista and then enter the correct address depending upon whether the code was found.

I have the code to do this in the same Excel file but on a different worksheet but not using an external Excel file.

Any help or suggestions would be appreciated

 

[SkipVought]

Hi,
Here's what you can do...
In your Address column type = then menu item Window and select the target workbook and corresponding column -- the formula wind shoud look something like this

=[MyAddressList.xls]Sheet1!$A:$A

THAT is your lookup target reference. It's that simple! Skip,
metzgsk@voughtaircraft.com

 

[DaleWatson123321]

Skip,

I tried using your example, but perhaps it's been "toooo long a week"... I couldn't get it to work.

The option I used was the following, which DOES work.

=VLOOKUP(A1,Address_List.xls!address_table,2,FALSE)

This formula is in B1, and refers to the "code" the user would enter into A1. The "other" file is called "Address_List", and contains a "database" named "address_table". By using the range name for the table, it means not having to use the Sheet name.

I'd appreciate your feedback on this.

Thanks again,

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[SkipVought]

Dale,
I was a long week, and I was getting ready to whisk away my wife for an anniversary weekend. My solution is NOT. Sorry, dodgyone. :-( Skip,
metzgsk@voughtaircraft.com

 

[DaleWatson123321]

dodgyone,

Curious to know how you made out.

Can you please advise.

Thanks.

...Dale Watson dwatson@bsi.gov.mb.ca