Rhino_Dance
Board Regular
- Joined
- Jul 23, 2008
- Messages
- 74
I have a 'vlookup' formula in a cell. All the elements in the formula are valid and it should return any result (including an error). But the cell only displays the formula itself. My immediate guess was that through a series of random and unluck keystrokes I had invoked TOOLS / OPTIONS / VIEW / FORMULAS (checked). That's not the case though.
Here is the formula:
=vlookup(M2,CA_NV_LK,2)
Been at EXCEL a long time and this one's truly a headscratcher. Using XL 2003. Thanks.
Here is the formula:
=vlookup(M2,CA_NV_LK,2)
Been at EXCEL a long time and this one's truly a headscratcher. Using XL 2003. Thanks.