So, I have a variable form a textbox that when I try to use it inside the xlookup formula it can’t find the item, even though I’m looking at it. However, if I type the number directly into the formula it works. I’ can’t wrap my head around why is it not working.

I am using excel 2021 version. Unable to apply Xlookup in vba. I have employee id against which I want to get name for the female employees only. I have two columns. Employee name(column 1) and Sex(column 2). I am guessing what could be the vba code to get female employee names only.