I’m trying to compare 2 tables cell by cell, and what I want to achieve is getting ‘#N/A’ (using XLOOKUP function) in every cell that differs from the first table.
So, I would like to see “#N/A” in cells N8:P10. My function looks like that:
=XLOOKUP(I8,C:C,C:C)
Table 1
How can I change it to show correct results?
Thanks for help in advance!
New contributor
Koneczek is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.