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" 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(....