Search Range and return True or False

[Grimace]

Good afternoon everyone

In the attached sheet, I am trying to search through the range AgentIDs (Blue) to see if the value in column w (yellow) is in the list. If it is, I want to return a True in column X (Green).

Not sure what would be the best function to use.

Restrictions are:
- the Agent ID field will not always be sorted in numerical order.
- Column W will vary in length month on month
- I have used a MID function in column W as the data extract comes with ' ' marks around it (column V), whereas the agent ID field is just typed in and remains constant. Not sure if this is effecting the outcome.

Any assistance would be greatly appreciated.

[Leith Ross]

Hello Grimace,

In column "W" the formula is now this:

=IF(ISNA(VLOOKUP(VALUE(W3),AB:AB,1,FALSE)),"", W3)

Conditional formatting has been added to column "W" also to either clear the color or make it green when a match is found in column "AB".

Format Condition 1: Formula Is =AND(ISTEXT(X3),X3="")
Format Condition 2: Cell Value Is not equal to 0

The attached workbook has the changes.

[Grimace]

Thanks Leith , exactly what I was after.

Really appreciate it, Darren.