Thread: Vlookups and wildcards?
View Single Post
  #4   Report Post  
wickedchew wickedchew is offline
Senior Member
  
Location: Philippines
Posts: 161
Default
Quote:
Originally Posted by Dave H View Post
Here is a sample
Try:

=IFERROR(VLOOKUP(LEFT(A11,3),Table2,2,FALSE),VLOOK UP(LEFT(A11,3)&"*",Table2,2,0))
__________________
Asobi Wa Owari Da
Reply With QuoteReply With Quote