Forum Discussion
machurch71
Nov 18, 2022Copper Contributor
Vlookup help
I'm trying to pull data one spreadsheet into another using Vlookup, the problem is the sheet with the data is more then one number in the same cell separated by comma and space
=VLOOKUP("*"& $E3 &"*",Invoice!$A$1:$G$3000,3,FALSE) this code only work part of the time
1 Reply
- Harun24HRBronze ContributorUse XLOOKUP() instead, with wild card matching option.