Try

=--INDEX(Sheet1!H:H,MATCH(B12,Sheet1!A:A,0),1)


--


Regards,

Peo Sjoblom


"dbl" wrote in message
. ..
Hi I have the following formula in cell B9

=INDEX(Sheet1!H:H,MATCH(B12,Sheet1!A:A,0),1)

Which brings the result I need, but when I have other cells that link to
B9 the rest of the spreadsheet doesn't work. When you look at the result
the number it finds is in a text format which my other formulas do not
recognise. How do I over come this problem?

If you type the number in the cell instead of using the Index Match
formula the rest of the spreadsheet works ok.

Any ideas would be very much appreciated.

Bob