| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Needed
It works, thanks to both you and Bob
-- Clark "Tyro" wrote: Assuming what you're looking up is in A1 and your lookup range is A1:B10 on sheet2 B1: =LEFT(VLOOKUP(A1,Sheet2!A1:B10,2,FALSE),25) The formula looks for an exact match in A1:A10 on sheet2 and returns the first 25 characters of the corresponding cell in B1:B10 "Clark" wrote in message ... I have two spreadsheets. Each has in common a unique identifier which is an 8 digit number used in both spreadheets. In one of the spreadheets there is a product description that can run to as many as 70 text characters. What I need is a sort of partial vlookup I think. Example: sheet 1 has a unique identifier of 40002796. I need a formula that will go to sheet 2 and bring over the first 25 text character (for my purposes thats as many as I work with) associated with 40002796. Is this doable? -- Clark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula needed. | Excel Discussion (Misc queries) | |||
| Formula needed | Excel Worksheet Functions | |||
| Formula needed, please | Excel Worksheet Functions | |||
| Formula Set Up Needed | Charts and Charting in Excel | |||
| formula needed | New Users to Excel | |||
Hybrid Mode
