|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
07-10-2008, 07:57 AM
|
|||
|
|||
|
VLOOKUP and pivot table
I have a VLOOKUP which looks for a value in column 8 of my pivot table. It doesn't pick the value up! If I substitute any of the other column numbers in the VLOOKUP it works. Somehow it can't access the values in column 8. What am I missing?
 
|
|
#2
07-10-2008, 08:30 AM
|
||||
|
||||
|
Hi,
Is column 8 actually in the table_array? VLookup( value, table_array, index_number, not_exact_match )
__________________
oldchippy -------------   Click here >>> Top Excel links for beginners to Experts Forum Rules >>>Please don't forget to read these
|
|
#4
07-10-2008, 10:56 AM
|
||||
|
||||
|
Quote:
__________________
oldchippy ------------- Click here >>> Top Excel links for beginners to Experts Forum Rules >>>Please don't forget to read these
|
|
#5
07-10-2008, 12:08 PM
|
|||
|
|||
Yes, you are right A - J is 10. Thing I forgot to mention is that I created a pivot table of 9 columns but outside the table I have a column with rows numbered 1 - 35. This isn't part of my pivot but it is part of my table array.
I eventually deleted the pivot and recreated it. For some odd reason the columns are in a different order now. I changed all my Vlookups to refer to the correct columns and it's now working.  I'm very new to Excel 2007 as you may have noticed... Thanks for your help.
|
|
#6
07-10-2008, 12:19 PM
|
||||
|
||||
|
Hi,
Glad to hear you have it working now, you may find this link helpful? http://www.datapigtechnologies.com/ExcelMain.htm
__________________
oldchippy ------------- Click here >>> Top Excel links for beginners to Experts Forum Rules >>>Please don't forget to read these
|
 |
| Bookmarks |
New topics in Excel 2007 Help
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
