New Contributor

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!




4 Replies
best response confirmed by allyreckerman (Microsoft)


Please check if column O is in General format, not Text. 

Yes. I saw that in another post on here. I have tried formatting Col O as Text and as General and there is no difference.
Solved. After changing the column format to General I had to click into the cell and hit <enter>. Thanks for the assistance!

@DMull34 , you are welcome