Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Formating a cell that contains the filter function

Copper Contributor

I have a vlookup in column K, that references column j, and column j is copied from the contents in column A, but column A has a filter function and I believe that's whats causing me to get the n/a error in column k. Is there a way fix the formatting in column A? I've made sure all the columns and source sheets that I used to create the formulas was formatted correctly, but I can figure out why this is happening. Thanks!

 

Example.JPG

1 Reply

@Kaytrishjr You don't mention the actual formula you are using in K. Just that it's a VLOOKUP. Difficult to determine what's causing the error. Looking at he screenshot, I suspect column A contains texts and column K has numbers. That would explain N/A.