Forum Discussion
XLook Up
I have 3 workbooks. One called PO number system and one for each project manager. Workbook 1 - PO Number system Workbook 2 - Marc Workbook 3 - Kyle On the PO Number System, Column A is dropdown ...
When I insert the formula into B2 I get an error - this function isn't valid. It is highlighting the word filter in the formula??
The FILTER function is available in Excel in Microsoft 365 and Office 2021.
Which version do you have?
I am not sure - I don't think it's the version you said. It's on my computer at my office. It works on my MAC at home. I have it saved on a flash drive. Will it work when I insert the flash drive into my computer at the office?
If you have an older version at work, the formula that I proposed won't work there.
- So, what do i need to change to get it to work on a previous version?