Share via

Excel vlookup with possible wildcard character in the center

Jonathan Brotto 1,076 Reputation points
2022-04-28T16:20:40.107+00:00

I am looking up an inventory list and notice between systems. For example an item might have a code 2100-CH in one system but in another system it is 2100CH. But there could be cases where there is an exact match.

Microsoft 365 and Office Excel For business Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. T. Kujala 8,761 Reputation points
    2022-04-28T17:54:41.137+00:00

    Hi @Jonathan Brotto ,

    Using wildcard characters in searches

    For example.

    =VLOOKUP(""&F4&"",C4:D13,2,FALSE)

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.