| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
I have two wok book. in one there are a lot of nos like
book no1 321127 92117-0002 in other book2 321127-00 0092117-02 how can we use vlook up |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup
If book2 is array Sheet2!A1:A100 try the below formula ..
Lookup value in cell A1 is from book no 1 . =VLOOKUP("*" & LEFT(A1 & "-",FIND("-",A1)-1) & "*",Sheet2!A1:A100,1,0) If this post helps click Yes --------------- Jacob Skaria "ideasailer" wrote: I have two wok book. in one there are a lot of nos like book no1 321127 92117-0002 in other book2 321127-00 0092117-02 how can we use vlook up |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup
Hi,
You can use a wildcard =VLOOKUP("*"&A2&"*",[Book2]Sheet1!$A$1:$B$20,2,FALSE) so if A2 contains 321127 it will find 321127-00 in book 2. Mike "ideasailer" wrote: I have two wok book. in one there are a lot of nos like book no1 321127 92117-0002 in other book2 321127-00 0092117-02 how can we use vlook up |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| 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 | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
