question

JonathanBrotto-3536 avatar image
0 Votes"
JonathanBrotto-3536 asked JonathanBrotto-3536 commented

Excel vlookup with possible wildcard character in the center

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.

office-excel-itpro
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

TKujala avatar image
0 Votes"
TKujala answered JonathanBrotto-3536 commented

Hi @JonathanBrotto-3536,

Using wildcard characters in searches

For example.

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

· 1
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JonathanBrotto-3536 avatar image JonathanBrotto-3536 ·

For the wildcard is there way to select for single characters?

0 Votes 0 ·