Vlookup on a formula field?

[Monish]

Hi
I am trying to run a Vlookup, but always return #N/A
I know the vaues exist from eyeballing some of them, but realized that the
values I am trying to return are in fact a result of a calculation (SUMIF's)
within the specified array...I am not sure if this is the problem but would
appreciate any thoughts.
Thanks for reading this.
i.e. vlookup(A2,Sheet1!AE:AF,4,False)
where column AF on Sheet1 = SUMIF(....

 

[L. Howard Kittle]

At first glance, AE:AF is only two columns and your third argument wants to
return a value four column to the right....?

HTH
Regards,
Howard

 

[Monish]

Thanks for the responses...I apologize but the formula should have read
"...AC:AF,4,False)" The issue appears to be that it is calling a value that
is itself a caclulated field...is that something that VLookup does not
accomodate?

Thx

 

[dan dungan]

I'm wondering what is the data in AC:AF?

Does your calculated field return a value?

 

[L. Howard Kittle]

I would be glad to look at a sample worksheet showing your Vlookup formula.
Add in comments of what you want the results to be in a before and after
condition of the formula.

Regards,
Howard

 

[Monish]

Dan

The value I am trying to return is in AF and is the result from a SUMIF
calculation of data within its own worksheet...does that make sense?

Thanks!

 

[Monish]

Not sure how I would attach a worksheet here...

As more background, the Vlookup function resides on Sheet 2 and is looking
up a value from Sheet 1...this value on Sheet 1 is itself calculated
(SUMIF's) from data on Sheet 1...

Hope that helps a bit?

Thanks