Hi
I'm trying to use Vlookup to find just part of a text string in a cell. The formula below works OK for cells with small amounts of text (one line across the top) but doesn't work with larger cells. (Below is an example one of the large cells, this text is all in one cell on excel ie A3). On the example below if i delete half of the contents of that cell the vlookup will work fine.
Any ideas?
<colgroup><col></colgroup><tbody>
</tbody>
=VLOOKUP("*"&A2&"*",Sheet1!A:B,2,FALSE)
</pre>
I'm trying to use Vlookup to find just part of a text string in a cell. The formula below works OK for cells with small amounts of text (one line across the top) but doesn't work with larger cells. (Below is an example one of the large cells, this text is all in one cell on excel ie A3). On the example below if i delete half of the contents of that cell the vlookup will work fine.
Any ideas?
2C.20770.001, 2C.20770.011, 2C.20C30.001, 3UR18650F-2-QC-CH3, 3UR18650F-2-QC-CH3A, 3UR18650F-2-QC-CH3X, 7813540000, 7813570000, 916C5810F, 916C5820F, 916C5840F, 916C7170F, BATSQU704, DHR504, EUP-P2-4-24, SQU-701, SQU-704, SQU-705, SQU-712, SQU-714, EUP-PE1-4-22, EUPPE1422, 2C.20990.001, 2C.20C30.021, 2C20990001, 2C20C30021, 916C7170F, 916C7620F, DHR503, 16C7620F, DHR503, DHR504, PB2Q-424, PB2Q424, PB2Q424, PE1-4-22, PE1422, |
<colgroup><col></colgroup><tbody>
</tbody>
=VLOOKUP("*"&A2&"*",Sheet1!A:B,2,FALSE)
</pre>