Thread: Match Data in Column 1 from table & place number in Column 2

Hello,

I have a column of data (Column A) and a data table of numbers. I want to check Column A for number X. If the X number is equal to any numbers in the table then put "60" in Column B. If the number is not equal to any of the numbers in the table then put "10" in column B. Here is an attached example of what I am trying to do.

Best,

Frank

Hi, maybe
=IF(COUNTIF($D$3:$D$30,A3)>0,60,10)
or
=IFERROR(VLOOKUP(A3,$D$3:$E$30,2,FALSE),10)