|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
| Notices |
 |
|
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
08-30-2006, 11:21 AM
|
|||
|
|||
|
Vlookup displaying all possible matches
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 Last edited by Eladamri; 08-30-2006 at 11:24 AM. 
|
|
#2
09-20-2006, 09:16 PM
|
|||
|
|||
|
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:
|
|
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
