Thread: Searching Multiple rows using VLOOKUP with wildcard(*,?) lookup va
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tommy Tommy is offline
external usenet poster
  
Posts: 70
Default Searching Multiple rows using VLOOKUP with wildcard(*,?) lookup va
Given data_array:

abc 1000
abx 2000
bcd 3000
def 4000
bhg 3200

and lookup_value is b??, how can we obtain result with

bcd 3000
bhg 3200

using VLOOKUP

thanks.
Reply With QuoteReply With Quote