Can I use vlookup and forecast functions at once.
Say vlookup searches for the multiple matches it finds for the actual item
and then from all these data can I use the forecast function.

Vlookup doesn't fine multiple matches.

I don't believe forcast will work with non-contiguous cells.

--
Regards,
Tom Ogilvy


"vijaya" wrote in message
...
Can I use vlookup and forecast functions at once.
Say vlookup searches for the multiple matches it finds for the actual item
and then from all these data can I use the forecast function.

Forecast does work with contiguous cells, iam not sure of Vlookup..Vlookup
seems to be complicated to me

"Tom Ogilvy" wrote:

Vlookup doesn't fine multiple matches.

I don't believe forcast will work with non-contiguous cells.

--
Regards,
Tom Ogilvy


"vijaya" wrote in message
...
Can I use vlookup and forecast functions at once.
Say vlookup searches for the multiple matches it finds for the actual item
and then from all these data can I use the forecast function.

Vlookup only returns the requested value for the first occurance of the
lookup value in the leftmost column of the lookup range.

--
Regards,
Tom Ogilvy


"vijaya" wrote in message
...
Forecast does work with contiguous cells, iam not sure of Vlookup..Vlookup
seems to be complicated to me

"Tom Ogilvy" wrote:

Vlookup doesn't fine multiple matches.

I don't believe forcast will work with non-contiguous cells.

--
Regards,
Tom Ogilvy


"vijaya" wrote in message
...
Can I use vlookup and forecast functions at once.
Say vlookup searches for the multiple matches it finds for the actual
item
and then from all these data can I use the forecast function.