snowman1976
Board Regular
- Joined
- Nov 4, 2008
- Messages
- 191
hello
I am hoping someone can help with a formula I need to return a value based on a wildcard. I made a small example below. In one worksheet I have a list of wildcard values with correlating data in column B (AB430, AS430, etc). On a separate worksheet I have the values listed , but this time full part number, and I want a formula to return the corresponding data from column B. is there a formula that can do this? I already have a different check in place to make sure no two wildcards are alike in the first sheet, so there should only be on 1 possible match
A B
68058679* AB430
60630-TR3 -A500* AS430
8A8Z-7410608* AD440
68058679AZ-A result here
I am hoping someone can help with a formula I need to return a value based on a wildcard. I made a small example below. In one worksheet I have a list of wildcard values with correlating data in column B (AB430, AS430, etc). On a separate worksheet I have the values listed , but this time full part number, and I want a formula to return the corresponding data from column B. is there a formula that can do this? I already have a different check in place to make sure no two wildcards are alike in the first sheet, so there should only be on 1 possible match
A B
68058679* AB430
60630-TR3 -A500* AS430
8A8Z-7410608* AD440
68058679AZ-A result here