Test for True using Match or Lookup

[Manesh]

Hi Chandoo

I would like to test if a value in Column C is equal to a value in Column A and then return Blank for True or Random for False.

I have attached a sample data sheet with the requirements.

Ideally the solution should not contain Macros or VBA code.

Kindly assist.

Thank you.

Best regards,
MN

 

[Nebu]

Hi:

Find the attached.

Thanks

 

[azumi]

Please see the file attach, hope this helps...