Formula for number available or not based on 2 condition

[Krypt]

Hello Everyone,

I have problem finding a formula to tel when a number is available or not depending on a data validating in column A and a table in column K.
The data "available or not" must appear in the cell next to de used number in column K.

I searched with IF, MATCH, VLOOKUP, but non of this helped me to find the solution of my problem.
Hopefully you will be my saving in this.

Kind Regards
Krypt (AKA Mike)

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(COUNTIFS(B:B,K80),"Not available","Available")

 

[Krypt]

Hello Fluff,

Your my saving it's exactly what i was searching for.
Thanks a lot.

Kind Regard
Krypt

 

[Fluff]

You're welcome & thanks for the feedback.