Hello from Steved

=INDEX(ParadoxBusType!I:I,MATCH($A6,ParadoxBusType !$K:$K,0))

Ok the above formula at cell A6, then looks in Col I:I in ParadoxBusType!
worksheet
once found looks in K:K for the value, it is not working
please what have I overlooked. the formula is in Cell D6.

The above is in the same folder instead of sheet1 I've named it
ParadoxBusType!.

Thankyou for taking time on my problem.

Your write-up and equaitn do not agree
Do you want the value from column I or K
If it is I and you want ot match in column K You may need to make sure that
you have a true match.

find what looks like a match in K and do A
=ParadoxBusType!$K4=A6 i
f the answer is other than "true" there is not a match
If they are numeric one may rally be text Try an
=value(Trim(ParadoxBusType!$K4))=A6 and
=value(Trim(A6))=ParadoxBusType!$K4
to see what you need to do o your equation.

"Steved" wrote:

Hello from Steved

=INDEX(ParadoxBusType!I:I,MATCH($A6,ParadoxBusType !$K:$K,0))

Ok the above formula at cell A6, then looks in Col I:I in ParadoxBusType!
worksheet
once found looks in K:K for the value, it is not working
please what have I overlooked. the formula is in Cell D6.

The above is in the same folder instead of sheet1 I've named it
ParadoxBusType!.

Thankyou for taking time on my problem.

Thanks bj As you pointed out I had it the wrong way round

Thankyou very much for your time.

Cheers.

"bj" wrote:

Your write-up and equaitn do not agree
Do you want the value from column I or K
If it is I and you want ot match in column K You may need to make sure that
you have a true match.

find what looks like a match in K and do A
=ParadoxBusType!$K4=A6 i
f the answer is other than "true" there is not a match
If they are numeric one may rally be text Try an
=value(Trim(ParadoxBusType!$K4))=A6 and
=value(Trim(A6))=ParadoxBusType!$K4
to see what you need to do o your equation.

"Steved" wrote:

Hello from Steved

=INDEX(ParadoxBusType!I:I,MATCH($A6,ParadoxBusType !$K:$K,0))

Ok the above formula at cell A6, then looks in Col I:I in ParadoxBusType!
worksheet
once found looks in K:K for the value, it is not working
please what have I overlooked. the formula is in Cell D6.

The above is in the same folder instead of sheet1 I've named it
ParadoxBusType!.

Thankyou for taking time on my problem.