Re: Unable to 'FIND' in VLOOKUP Table

 [EMAIL PROTECTED] (leeha) writes:
>. . .
>The table and formulas work well and have the desired effect, however
>my only problem is that when I select 'FIND' in order to locate a
>given piece of data quickly, it will not recognise any of the data
>within the table that has a VLOOKUP formula within the cell.
>. . .

In the Find dialog box, you'll see a drop-down listbox labeled "Look-in:" which
propbably displays "Formula."  Change it to "Value" and try again. (Note also
the check boxes "Match case" and "Find entire cells only."