Vlookup evaluation

[Mick]

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

 

[Mike H]

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

 

[vezerid]

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