SOLVED

XLOOKUP

Copper 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!

 

DMull34_1-1626118401078.png

 

4 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@DMull34 

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

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@DMull34 

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

View solution in original post