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