| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
I have a column which contains the following type data
0125 - BYK-CRI-CC-SMITH All I care about is the 0125. Is there a formula that I could use that would vlookup if a cell contains certain data. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup
You can use LEFT(A1,4) to extract just the first 4 characters, but
you'll have to give some more detail on how your data is laid out and what you want to do if you want more advice. Hope this helps. Pete On Dec 6, 8:30 pm, Curtis wrote: I have a column which contains the following type data 0125 - BYK-CRI-CC-SMITH All I care about is the 0125. Is there a formula that I could use that would vlookup if a cell contains certain data. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
