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