General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Vlookup ~ formatng
To clarify, I get a 'n/a' response in the formula, but when i copy and and paste the lookup cell to the table (or the other way around), the formula work. I have tried formating the lookup column the same as the table column i.e. text or number but it does not seen to work. This gives me a headache specially when the lookup cell is within a pivot table.
suggestions pls !!!!!