L
LJSM
I am thinking this will probably end up being vB - I do this all the
time when creating search engines...
I have a list of electricity/gas/water suppliers, dependent on the
region of a city, in some cases, the suburb might have two...so I might
have a list like this:
Suburb Post Code: Elec Supplier: Gas Supplier:
3182 A
1
3183 A
2
3183 B
2
Now - if I do a little lookup function to make searching easy (having
1700 entries) - If you put in 3182 it will return with the supplier as
"A" and "1". However, 3183 will return as "A" and "2" - when it should
return TWO - A & 2 and B & 2. I could do a search function where it
returns them both - can you do this with VLOOKUP? Any ideas?
time when creating search engines...
I have a list of electricity/gas/water suppliers, dependent on the
region of a city, in some cases, the suburb might have two...so I might
have a list like this:
Suburb Post Code: Elec Supplier: Gas Supplier:
3182 A
1
3183 A
2
3183 B
2
Now - if I do a little lookup function to make searching easy (having
1700 entries) - If you put in 3182 it will return with the supplier as
"A" and "1". However, 3183 will return as "A" and "2" - when it should
return TWO - A & 2 and B & 2. I could do a search function where it
returns them both - can you do this with VLOOKUP? Any ideas?