Excel IF function query

[feriso]

Just asking if there is an easier way to write an IF string.

Basically I want to see if a value in (lets say) cell C15 is in listed in cells C4 to D4 if so display "x".

I can do this through repeated nested IF functions but looks a bit messy so I thought whether there is an option to do something like this:-

=IF(C15=RANGE(C4:H4),"X",)

where RANGE is some other function

Thanks

 

[Participant]

I would do it as follows:

=IF(ISERROR(VLOOKUP(C15,$C$4:$D$4,1,FALSE)=TRUE),"Not found","X")

 

[feriso]

Yup that works - though but I changed it to a hlookup, thanks!