If MATCH function where number not found

[colinheslop1984]

If I have a sequence of numbers running vertically in column A, e.g

1901
1902
1903...up to 1952

If I have a number in cell G3 that is not found in my list, eg 1953, I want the function to then give me the number provided in G4 instead

I know i'll want an IF function but cant figure it out. Hopefully that makes sense

Any ideas please anyone?

 

[Fluff]

What do you want to return if G3 is found in the list?

 

[colinheslop1984]

what do you want to return if g3 is found in the list?

h3+1

 

[Fluff]

Ok, how about
=IF(ISNA(MATCH(G3,A2:A20,0)),G4,H3+1)

 

[colinheslop1984]

Perfect.

Thank you

 

[Fluff]

You're welcome & thanks for the feedback

 

[jtakw]

Hi,

Another way using COUNTIF:

=IF(COUNTIF(A1:A52,G3),H3+1,G4)