Ok, Bob Phillips.
Many thanks.
Work fine.
an
-----Original Message-----
=INDEX($B$1:$B$1000;MATCH(C1;$A$1:$A$1000;0);1)
at a guess
--
HTH
RP
(remove nothere from the email address if mailing direct)
"an" wrote in
message
...
Hello!
I use next formulae and work fine
=INDEX($A$1:$B$1000;MATCH(C1;$B$1:$B$1000;0);1)
where
A B
Number Text
Now, I would a formulae where columns change.
A B
Text Number
Thanks in advance.
an
.
|