Forum Discussion
JCBenny
Jun 13, 2023Copper Contributor
Double Xlookup not working for what I need
So I am trying to pull information from two charts that have a matching identifying value, however the information in the columns following that unique value can be different and these values can rep...
JCBenny
Jun 17, 2023Copper Contributor
mtarler It returned "none". I triple checked to make sure I had I did it right.
mtarler
Jun 17, 2023Silver Contributor
If you replace "out" on line 5 with "AllUniq" or "NonOverlap" you can see more of what is happening. But this same formula works on the attached. If you send me a copy of the actual sheet (no private info) I might help more.