S
Simon Topping
Hello,
Given the following information:
Col A Col B Col C
Company Source 1 Source 2
1 Company 1 10 ?
2 Company 1 170 ?
3 Company 1 20 ?
4 Company 1 4 ?
I am trying to lookup information for 'company 1'
from 'source 2', based on the information given in 'source
1'.
The information for in 'source 2' is not exactly the same
as in 'source 1' so I need to return the closest match.
Does anyone know how this can be done? Any assistance will
be greatly appreciated.
Simon
Given the following information:
Col A Col B Col C
Company Source 1 Source 2
1 Company 1 10 ?
2 Company 1 170 ?
3 Company 1 20 ?
4 Company 1 4 ?
I am trying to lookup information for 'company 1'
from 'source 2', based on the information given in 'source
1'.
The information for in 'source 2' is not exactly the same
as in 'source 1' so I need to return the closest match.
Does anyone know how this can be done? Any assistance will
be greatly appreciated.
Simon