Hello,

I would like to ask for help. Am I able to vlookup from a field? Here is
what I'm doing:

- on sheet two I have a lookup field (Column 1 is the percentage, column 2
is the amount paid if that percentage is reached)

- in Sheet 1 I have a quota listed in A1; the actual amount reached in A2,
and the percent to quota in A3 (A2/A1)

In A4 I would like to have the lookup return the paid out amount based on
the percentage shown in A3, however I am receiving a #N/A.

The only thing I can think of is that I cannot use a vlookup for this type
of calculation.

Any suggestions on how I may be able to complete this task?

Thanks
Jim