Why do I get a #NA error when I do a VLOOKUP on a cell that contains a
formula? Is this because its trying do the lookup on the formula
itself and not the data displayed in the cell due to the formula?

=VLOOKUP(E2,PRODTAB,3,FALSE) Where (E2) contains a formula that
processes information from another cell.

I know every thing else is ok because when I type in the display
formula result from (E2) into a (E3) and change the VLOOKUP to
=VLOOKUP(E3,PRODTAB,3,FALSE) it works.

Thanks
Very Confused