Hi

I have a formula - =index(B1:B10,(match(C1,A1:A10,0)))

however when there is a blank in row B it returns a 0, how can I change it to enter a blank instead?

many thanks

andrewm