Jul 12 2021 12:41 PM
I am using XLOOKUP. It works in Column N (formula visible in formula bar at top). I am trying to do a similar XLOOKUP in Column O. Same formula as in Column N except that I changed the lookup and return array columns. I can't figure out why Column O just displays the formula. What am I doing wrong!
Jul 12 2021 12:49 PM
SolutionPlease check if column O is in General format, not Text.
Jul 12 2021 12:51 PM
Jul 12 2021 02:02 PM
Jul 12 2021 12:49 PM
Solution