Need help with ISNA formula

hello,

I am in need of some expert :-) help with a very stuborn formula.
I don't know what I am doing wrong but at least I am not getting the result I expect.

I have a large sheet of data in which I have a column named "Status"
The cells are filled with numbers which refer to a status description

I have created a new sheet called "Stat" in which I have 2 column

Column A is the column with the status codes
Column B is the colum with the status description of the code

In my main data sheet I have created a new column called "Status description" which holds the following formula:

=IF(ISNA(MATCH([Status];Stat!A:A;0));"";INDEX(Stat!B:B;MATCH([Status];Stat!A:A;0)))

I don't know why but there is no result, i.e. description appearing.
I have used the above formula before with other spreadsheet but now it does not seem to work.

Am I overlooking something ?
Is this perhaps not the right formula when using numbers ?

Hi, just an attempt

your formula looks correct, maybe in your file someone has selected manual calculation in tools-options-calculation tab.

Regards

See attached the sheet

I tried the formula from daddylonglegs but it did not do the trick

Hi,

I've made a little change in G2

=IF(ISNA(MATCH($F2*1,Stat!A:A,0)),"",INDEX(Stat!B:B,MATCH($F2*1,Stat!A:A,0)))


Hope it helps

Hi,

I tested the formula from CANAPONE and it did the trick !

Thanks all for your inputs