how can Vlookup display all possible matches? that means the whole data in the cell in which the lookup value can be found is reflected.

for example:
Lookup Value is 456

Column A Column B
123456 =vlookup(456,.....
223456 =vlookup(456,.....
333456 =vlookup(456,.....
456 =vlookup(456,.....
CN456 =vlookup(456,.....
456 =vlookup(456,.....

Will give the result:
Column A Column B
123456 123456
223456 223456
333456 333456
456 456
CN456 CN456
456 456