Hi

Have some data that is averaged so

x = average(range)

When I try to run a vlookup on x get a 'value not available error'.

Any ideas?

Mick

Hi,

I'm not sure I understand you but maybe this. Columns A & B are your data
and you want to do a vlookup on the average of column A

=VLOOKUP(AVERAGE(A1:A100),A1:B100,2,TRUE)

Note column A must be sorted ascending for this to work.

Mike


"Mick" wrote:

Hi

Have some data that is averaged so

x = average(range)

When I try to run a vlookup on x get a 'value not available error'.

Any ideas?

Mick

Do you have any reason to expect that the computed average will also
be a value in the first column of your lookup table? The most likely
scenario is that it will not be found. Do you by any chance try to
find the value closest to the average? If so, you need to specify TRUE
as 4th argument (or omit it).

HTH
Kostis Vezerides

On Feb 25, 2:45 pm, Mick wrote:
Hi

Have some data that is averaged so

x = average(range)

When I try to run a vlookup on x get a 'value not available error'.

Any ideas?

Mick