09-20-2006, 09:16 PM
|
|
Forum Guru
|
|
Join Date: 13 Mar 2005
Posts: 6,202
|
|
The question is a little old, but what you want can be achieved in a separate column.
=IF(LEN(SUBSTITUTE(A1,"456",""))=LEN(A1),"",A1)
or perhaps
=IF(LEN(SUBSTITUTE(Sheet1!A1,"45L",""))=LEN(Sheet1!A1),"nomatch",Sheet1!A1)
so that you can Filter and delete all 'nomatch' rows.
---
Quote:
|
Originally Posted by Eladamri
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
|
|