Change column Number vrs Text
 

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

=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

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



.