Run a search using a value in the cell above

[Lethe]

Hey,

I'm trying to run a search through some cells for a value located above the cell that has the search function.

I'm trying to use this:
=ADDRESS(2;MATCH(A5;A1:UX1;0);4)

Where A5 is where I have a number which I want to search for.
I also tried this instead of A5:

=ADDRESS(2;MATCH(INDIRECT(ADDRESS((ROW()-1);COLUMN();4));A1:UX1;0);4)

But also didn't work.
However, if I replace it for a number, the search function works. How come?

Thanks