A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hi Hope,
Thank you for your response.
Please try using the following formula and check whether it resolves the issue:
=XLOOKUP(A3&"",POs!I:I&"",POs!J:J)
This formula forces the values to the same data format before performing the lookup, which helps avoid situations where the values appear identical but are stored as different data types.
I hope this information is helpful.
If you have any questions or need further assistance, please feel free to share them in the comments on this post so I can continue to support you.
I look forward to continuing the conversation.