Search

[Steved]

Hello from Steved
How would one go about writing a formula to search for
2.0 (Which is distance)I have over 1,000 places in my
worksheet. below is one sample of over 1000

From Middelemore to Otahuhu is 2.0 Kilometres.

What I do is type Middlemore in cell A1 and type in
Otahuhu in cell A2 and in cell A3 the formula will search
for what I had typed in A1, A2. In this case it will be
2.0 (cell AT102)

Cell AT100 Middlemore
Cell AT101 Otahuhu
Cell AT102 2.0
Thankyou

 

[Steved]

Hello from Steved

I type in Middlemore in Cell A1 and Hospital in A2
The formula will find Middlemore in F12 and Hospital in
F13 the formula will return the information in F14 to A3
which is 4.7
C D E F
4 Otahuhu St Pius St Marys Arthur St
5 Inter School Wiri Penrose
6 7.0 15.4 13.5 4.0
7
8 Rosehill Sutton Park Penrose High Britomart
9 Intermediate Pap High Panmure Washington
10 15.0 5.4 5.2 10.4
11
12 Massey Rd Fairburn Otahuhu T.C Middlemore
13 Robertson Primary McAuley High Hospital
14 6.1 6.5 0.6 4.7