XLOOKUP + VLOOKUP error

[Cookdem]

Hi all!

I am having an issue with XLOOKUP and VLOOKUP and can't figure out if it is a formatting error with the text, specifically the 'XH' at the start of the text

To my eyes, I have checked the data set both sides and the format is the same for both so the lookup's should work

The formula presenting as #VALUE is =IFNA(IF(XLOOKUP(B26,'New Timesheet'!C:C,'New Timesheet'!C:C,0,0,1),"Y","N"),"N")
The formula next to it is =IFNA(IF(AND(XLOOKUP(B26,'New Timesheet'!C:C,'New Timesheet'!C:C,0,0,1),'New Data Tab'!G26=40),"Y","N"),"N")

Is there something really obvious I'm missing? The other really odd thing is that the 2nd formula presents correctly, even though it is exactly the same as the first but with more criteria!

Please let me know if you need more info and thanks in advance!

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(ISNUMBER(XMATCH(B26,'New Timesheet'!C:C)),"Y","N")

 

[Cookdem]

Hi & welcome to MrExcel.
How about

=IF(ISNUMBER(XMATCH(B26,'New Timesheet'!C:C)),"Y","N")

Thank you very much, worked like a charm

 

[Fluff]

You're welcome & thanks for the feedback.