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

Monish;239783 Wrote:
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

"L. Howard Kittle" wrote:

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" wrote in message
...
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(....





--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64766