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

J

JOE

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?
 
T

TomPl

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

Tom
 
S

Shane Devenshire

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
 
Top