Vlookup evaluation

  • Thread starter Thread starter Mick
  • Start date Start date
M

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
 
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
 
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
 
Back
Top