Hi from Sunny RSA,

I have a list on sheet Vehicles:
Column A Column B
BEM 98D03
ALR 97R03
BEM 96R02

Now on another sheet called Depot info, I have got:
BEM (in cell B2)
In cell C2 I want a formula that will return 98D03 and in cell C3 I want to
return 96R02

So the formula must vlookup return the value, then in the next cell below
run the vlookup again and if the result is the same as in cell c2, do not
return a value, but if it is different ..... haha that is the problem

Thanks