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

 

[Simon Lloyd]

You are trying to return a value outside of the scope of your Vlooku
try this *=vlookup(A2,Sheet1!AE:AH,4,False)*

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

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[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

 

[Simon Lloyd]

Monish, you can join the forum below (The Code Cage) for free where yo
can attach a workbook for all to see, if you do join please post in th
thread indictaed below so that those who have been helping or folllowin
this thread can continue to do so

Not sure how I would attach a worksheet here..

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

Hope that helps a bit

Thank

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com