Thread
:
VLookup 1st 9 char of Lookup range
View Single Post
#
11
Posted to microsoft.public.excel.misc
JP[_3_]
external usenet poster
Posts: 168
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
Reply With Quote
JP[_3_]
View Public Profile
Find all posts by JP[_3_]