Change column Number vrs Text

[an]

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

 

[Bob Phillips]

=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]

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)





.