Urgent Help needed ( Opposite of VLOOKUP)

[afzalzada]

Dears,
I have attached sheet and want to highlight or bring out only those GSM numbers which correspond the contract numbers in the right.
( each contract may have more than one GSM number but I want all GSM numbers which are connected only to Contract numbers to the right i.e 139 numbers ). thanks


Help.xlsx

[spitfireblue]

If you just want to highlight them...
In B2 use a conditional format formula with:

Please Login or Register  to view this content.

Then copy that format down column B

[Khalidngo]

Hi Afzal,

I think you should create a helper column say column c with this in c2:
=COUNTIF($A$2:$A$49783,F2)
copy down till C49783

Now select your range B2:B49783
Go to conditional formatting > Formula:
=C2>0

Set a format as required and hit ok.

This can be achieved without helper column, but it may slow down your calculation.

Regards,

[Kevin#]

Another solution.
Select values in columns A and B

then create a new rule in conditional formatting, using formula
=ISERROR(MATCH($A2,$F$2:$F$140,0))=FALSE

and apply chosen formatting

(see attached)