Hi Friend,

I have a table like that

product price
A123 10
A2456 5
B12 10
D5 5
C* 8 <- "C*" represent all product with the product code start with "C"

I can use vlookup to search the price of A123,A2456.
but if I want to search "C123","C456", how can I get the result is 8?

Thanks.