Excel Query IF Function

[Efigment]

Hello Excel Experts,

I need assistance checking values from 2 different sheets and to have it return an active or inactive value.

if values in cell range B2 through B85969 (sheet1) are equal to any value of range A2 through A800 (sheet2) to return a value of either Active if True or Inactive if False in sheet 1 cell range P2 through P85969.

Hoping to have been clear with my issue.

 

[Joe4]

Welcome to the Board!

Place this formula in cell P2 on Sheet1 and copy down for all rows:

=IF(COUNTIF(Sheet2!A$2:A$800,Sheet1!B2),"Active","Inactive")