Finding Contents of a Specific Cell (Address) out of 1000's of Add
 

I have a spreadsheet with 1000's of addresses, I am specifically looking for
one address to connect to another spreadsheet. How can I minimize time
searching/finding "one" specific cell? How can I connect two spreadsheets?
--
JOE :)

Finding Contents of a Specific Cell (Address) out of 1000's of Add
 

Possibly use VLOOKUP

"JOE" wrote:

I have a spreadsheet with 1000's of addresses, I am specifically looking for
one address to connect to another spreadsheet. How can I minimize time
searching/finding "one" specific cell? How can I connect two spreadsheets?
--
JOE :)

Finding Contents of a Specific Cell (Address) out of 1000's of Add
 

You could probably use the vlookup formula, but you have provided so little
detail about the structure of your spreadsheets.

Tom

"JOE" wrote:

I have a spreadsheet with 1000's of addresses, I am specifically looking for
one address to connect to another spreadsheet. How can I minimize time
searching/finding "one" specific cell? How can I connect two spreadsheets?
--
JOE :)

Finding Contents of a Specific Cell (Address) out of 1000's of Add
 

Hi,

1. Sort the addresses that will make your search much faster

2. or select the addresses and choose Data, Filter, AutoFilter and pick the
address from the sorted list or unique addresses.

3. You can connect to sheets in 1000's of ways it all depends on what you
want to do.

Once you've found it what do you want to do with it?

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"JOE" wrote:

I have a spreadsheet with 1000's of addresses, I am specifically looking for
one address to connect to another spreadsheet. How can I minimize time
searching/finding "one" specific cell? How can I connect two spreadsheets?
--
JOE :)