Vlookup help

Copper Contributor

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
Use XLOOKUP() instead, with wild card matching option.