Ifna(xlookup)

[WildBio92]

i have a table entitled "Weed Info" which contains data that I want to lookup through Lookup and XLookup functions. If the information to look up is not in the table (column A), i want the result to be a blank cell. I have created the function below to look up this data, but instead of a blank cell i get a zero (0) returned. Could someone let me know what I am doing wrong? I have also tried using IFERROR but get the same results.

=IF($C$5="","",IF(IFNA(XLOOKUP($C$5,'Weed Info'!A:A,'Weed Info'!B:B),FALSE),(XLOOKUP($C$5,'Weed Info'!A:A,'Weed Info'!B:B)),""))

[CARACALLA]

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[JohnTopley]

Try

Please Login or Register  to view this content.

[TMS]

XLOOKUP isn't structured like that. Try this:

Please Login or Register  to view this content.

[JohnTopley]

If blank cell required then from TMS reply:

Please Login or Register  to view this content.

[WildBio92]

Let me know if this helps

[WildBio92]

I guess I was over thinking it, thanks John

[JohnTopley]

Thanks are really due to TMS.

[TMS]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon (Next to Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.