Stumped with a IF foumula

[Lensmeister]

Hi all,

This might be easy but for some reason I am struggling.

I have two sheets:

Data
Sightings

I have a list of items in the Data sheet in column A

In the Sightings Sheet I have a list of items (sometimes multiple items of the same) in column B

On the Data sheet in column D I have tried this formula

=if(A2=Sightings!B114:B128,"X","")

Basically if the item in A2 is found in the sightings column B then it places a "X" in the cell D2 if not it leave it blank.

But it doesn't work.

Can someone please advise ?

[FDibbins]

try this...
=if(iserror(vlookup(A2,Sightings!B114:B128,1,0),"","X")

[Craig K.]

Try this

Please Login or Register  to view this content.

[Lensmeister]

Both work fine, Thanks you

[FDibbins]

Happy to help