| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup on a formula field?
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(.... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vlookup on a formula field?
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(.... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vlookup on a formula field?
You are trying to return a value outside of the scope of your Vlookup try this *=vlookup(A2,Sheet1!AE:AH,4,False)* Monish;231957 Wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vlookup on a formula field?
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 "Simon Lloyd" wrote: You are trying to return a value outside of the scope of your Vlookup try this *=vlookup(A2,Sheet1!AE:AH,4,False)* Monish;231957 Wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vlookup on a formula field?
I'm wondering what is the data in AC:AF?
Does your calculated field return a value? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vlookup on a formula field?
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(.... |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vlookup on a formula field?
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! "dan dungan" wrote: I'm wondering what is the data in AC:AF? Does your calculated field return a value? |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vlookup on a formula field?
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(.... |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vlookup on a formula field?
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula, one field complex or multiple table field simple | Excel Discussion (Misc queries) | |||
| Vlookup from a formula field | Excel Discussion (Misc queries) | |||
| Formula to find average of field for all rows that contain another field | Excel Programming | |||
| create formula. 1 field constant and another field varies by inpu. | Setting up and Configuration of Excel | |||
| Vlookup not recognizing field | Excel Worksheet Functions | |||
Linear Mode
