JuicyMusic
Board Regular
- Joined
- Jun 13, 2020
- Messages
- 210
- Office Version
- 365
- Platform
- Windows
Hello again,
I have a formula that includes a VLOOKUP with a WildCard. It works beautifully, but I need to tweak the VLOOKUP portion. This formula currently brings back an employee name if the employee name is at the beginning of the target "text string".
I need the Vlookup to bring back the employee name no matter where within the target test string it is.
This formula brings back OsirusB for the following scenario:
Example employee name: OsirusB Example target text string: OsirusB, PhilipG, BreffuQ, HorusH, NannyQ, ColletteX, (employee last names are abbreviated and each separated by a comma)
This formula brings back #N/A for the following scenario:
Example employee name: OsirusB Example target text string: PhilipG, BreffuQ, OsirusB, HorusH, NannyQ, ColletteX, (employee last names are abbreviated and each separated by a comma)
FORMULA:
Thank you so much,
Juicy
I have a formula that includes a VLOOKUP with a WildCard. It works beautifully, but I need to tweak the VLOOKUP portion. This formula currently brings back an employee name if the employee name is at the beginning of the target "text string".
I need the Vlookup to bring back the employee name no matter where within the target test string it is.
This formula brings back OsirusB for the following scenario:
Example employee name: OsirusB Example target text string: OsirusB, PhilipG, BreffuQ, HorusH, NannyQ, ColletteX, (employee last names are abbreviated and each separated by a comma)
This formula brings back #N/A for the following scenario:
Example employee name: OsirusB Example target text string: PhilipG, BreffuQ, OsirusB, HorusH, NannyQ, ColletteX, (employee last names are abbreviated and each separated by a comma)
FORMULA:
Excel Formula:
=IF(OR($G9="Off/Vacation",$G9="--"),"--",
VLOOKUP("*"&$C9&"*",Thursday120320!$B:$C,2,0))
Thank you so much,
Juicy