View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
JP[_3_] JP[_3_] is offline
external usenet poster
 
Posts: 168
Default VLookup 1st 9 char of Lookup range

Nevermind, my idea tanked.


On Oct 19, 2:51 pm, JP wrote:
Hello,

Try it as an array formula?

{=index($G$36:$G$336,match(1,($E346=left($E$36:$G$ 336,9)),0))}

HTH,
JP