Return information in cell diagonal to found location

[CoolSnaz]

Hi people,

I hope you are all well.

I have a new problem, which goes like this...

We have four cells:

__A___B__
1|~ | 8
2|A | 9

The "~" represents an unknown character/word.

I need a formula that will identify the letter "A" in cell A2 and return the figure in B1.

Please note the only constant is the character "A" and the cells are random, for example "A" could appear in cell A100, which would mean I need the figure in cell B99.

Can anyone help?

Kind Regards
Coolsnaz

 

[pgc01]

Hi Coolsnaz

Try:

=INDEX(B:B,match("A",A:A,0)-1)

 

[CoolSnaz]

Thanks you

That worked perfectly.

Many Thanks
Coolsnaz

 

[CoolSnaz]

Thanks you

That worked perfectly.

Many Thanks
Coolsnaz