Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup for first n characters
I need for a lookup type formula that looks at a cell in workbook1, then does
a lookup in workbook2 for the 'root' part. So in workbook1 I have part numbers like ABCDEF, HIJK, LMNOPPQ, etc. In workbook2, I need to look through a list of parts like ABCDEF123k, HIJK54, LMNOPPQ999, and input this information into workbook1. So, ABCDEF would return the information from part ABCDEF123K. Any help would be greatly appreciated!! Thanks in advance! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup for first n characters
Try something like this:
A1 = lookup value = ABCDEF =VLOOKUP(A1&"*",'C:\TV\[dbase.xls]dbase'!$A:$B,2,0) -- Biff Microsoft Excel MVP "shairal" wrote in message ... I need for a lookup type formula that looks at a cell in workbook1, then does a lookup in workbook2 for the 'root' part. So in workbook1 I have part numbers like ABCDEF, HIJK, LMNOPPQ, etc. In workbook2, I need to look through a list of parts like ABCDEF123k, HIJK54, LMNOPPQ999, and input this information into workbook1. So, ABCDEF would return the information from part ABCDEF123K. Any help would be greatly appreciated!! Thanks in advance! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup for first n characters
Try This
LOOKUP(1E+300,SEARCH($A$2:$A$4,E2),$E$2:$E$4) "shairal" wrote: I need for a lookup type formula that looks at a cell in workbook1, then does a lookup in workbook2 for the 'root' part. So in workbook1 I have part numbers like ABCDEF, HIJK, LMNOPPQ, etc. In workbook2, I need to look through a list of parts like ABCDEF123k, HIJK54, LMNOPPQ999, and input this information into workbook1. So, ABCDEF would return the information from part ABCDEF123K. Any help would be greatly appreciated!! Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert 5 characters in a cell to 6 characters by adding a zero | Excel Discussion (Misc queries) | |||
Insert Leading Characters If String Is Only 7 Characters | Excel Discussion (Misc queries) | |||
lookup with some specific characters | Excel Worksheet Functions | |||
Lookup strings with ~ and ^ characters | Excel Worksheet Functions | |||
In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions |