•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Find partial value within larger value for use in xlookup
Hey all,
I have two worksheets.
Worksheet 1 is from my client with their facility name in Column B (such as "Facility A").
Worksheet 2 is generated from my system, which has returned "Parent Corporation: Facility A", along with our Netsuite Internal ID (which I'm trying to return) in Column C.
I'm trying to look up the partial facility name given to me by my client in Worksheet1 against the full name given by my system in Worksheet2, to return Column C.
My attempts are failing miserably. So far I've tried:
=XLOOKUP("*"&B2&"*",Worksheet2!D:D,Worksheet2!C:C,"",0) I know this Facility A definitely exists in both worksheets.
What am I doing wrong?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#financial modeling with spreadsheets
#rows.com
#Excel alternatives for data analysis
#Excel compatibility
#no-code spreadsheet solutions
#natural language processing for spreadsheets
#generative AI for data analysis
#XLOOKUP
#partial facility name
#Worksheet 1
#Worksheet 2
#facility name
#Netsuite Internal ID
#Column B
#Column C
#Parent Corporation
#lookup
#value
#attempts
#worksheets