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 

 

machurch71_0-1668819953283.png

 

1 Reply
Use XLOOKUP() instead, with wild card matching option.