Thread: Formula Needed
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Clark Clark is offline
external usenet poster
 
Posts: 49
Default Formula Needed

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