View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jonathan May
 
Posts: n/a
Default Wildcard vlookup perhaps?


Humm, interesting - I have other strings of 3 and 4 characters but I'm
using Len() to look at the appropriate list.

Is there any way of doing the "indexed matched search" so that you
could ensure you're only looking at, say, characters 1, 3, and 6, e.g.
so that P*2**5, would give a distinct value from P**2*5?

Luckly only the left and right ends of my string change so (at the
moment) this case doesn't apply and I'm not desperate for an answer :)


Thanks again!


--
Jonathan May
------------------------------------------------------------------------
Jonathan May's Profile: http://www.excelforum.com/member.php...o&userid=10924
View this thread: http://www.excelforum.com/showthread...hreadid=502893