|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
April 23rd, 2005, 01:12 PM
|
|||
|
|||
VLOOKUP Help
I have a Workbook with multiple sheets.... On one sheet I have a unique
identifier which provides me with certain information and have acquired another which gives me more, but also has the same unique identifier... I wish to import this into the one sheet for reference, however this is not performing as expected. THe sheet I am trying to copy from has 2 columns of data column 1 being the unique index and column 2 being the data to be copied I have used a VLOOKUP function on the main page viz: =VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the unique index in the main sheet. I am however getting the error "Value not available" although doing an individual find on the other sheet finds it is there ??? Any help greatfully appreciated Alan 
|
|
#2
April 23rd, 2005, 01:22 PM
|
|||
|
|||
|
Alan,
Check that the lookup value and the unique ids are exactly the same. On a matching item, do a LEN(C3) and LEN(Ax) to see that there are no extraneous spaces in there. -- HTH RP (remove nothere from the email address if mailing direct) "Alan" wrote in message ... I have a Workbook with multiple sheets.... On one sheet I have a unique identifier which provides me with certain information and have acquired another which gives me more, but also has the same unique identifier... I wish to import this into the one sheet for reference, however this is not performing as expected. THe sheet I am trying to copy from has 2 columns of data column 1 being the unique index and column 2 being the data to be copied I have used a VLOOKUP function on the main page viz: =VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the unique index in the main sheet. I am however getting the error "Value not available" although doing an individual find on the other sheet finds it is there ??? Any help greatfully appreciated Alan
|
|
#3
April 23rd, 2005, 01:40 PM
|
|||
|
|||
|
Bob
Sorry already tried that ... HAve used VLOOKUP before and this has me stumped ! Thanks anyways ... open to other suggestions "Bob Phillips" wrote: Alan, Check that the lookup value and the unique ids are exactly the same. On a matching item, do a LEN(C3) and LEN(Ax) to see that there are no extraneous spaces in there. -- HTH RP (remove nothere from the email address if mailing direct) "Alan" wrote in message ... I have a Workbook with multiple sheets.... On one sheet I have a unique identifier which provides me with certain information and have acquired another which gives me more, but also has the same unique identifier... I wish to import this into the one sheet for reference, however this is not performing as expected. THe sheet I am trying to copy from has 2 columns of data column 1 being the unique index and column 2 being the data to be copied I have used a VLOOKUP function on the main page viz: =VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the unique index in the main sheet. I am however getting the error "Value not available" although doing an individual find on the other sheet finds it is there ??? Any help greatfully appreciated Alan
|
|
#4
April 23rd, 2005, 02:06 PM
|
|||
|
|||
|
Hi Alan,
Are both items numeric or text? Check this with =ISTEXT or ISNUMBER, even if they look the same. And, with the 4th argument as FALSE, the table (Column A) has to be sorted ascending. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Alan" wrote in message ... Bob Sorry already tried that ... HAve used VLOOKUP before and this has me stumped ! Thanks anyways ... open to other suggestions "Bob Phillips" wrote: Alan, Check that the lookup value and the unique ids are exactly the same. On a matching item, do a LEN(C3) and LEN(Ax) to see that there are no extraneous spaces in there. -- HTH RP (remove nothere from the email address if mailing direct) "Alan" wrote in message ... I have a Workbook with multiple sheets.... On one sheet I have a unique identifier which provides me with certain information and have acquired another which gives me more, but also has the same unique identifier... I wish to import this into the one sheet for reference, however this is not performing as expected. THe sheet I am trying to copy from has 2 columns of data column 1 being the unique index and column 2 being the data to be copied I have used a VLOOKUP function on the main page viz: =VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the unique index in the main sheet. I am however getting the error "Value not available" although doing an individual find on the other sheet finds it is there ??? Any help greatfully appreciated Alan
|
|
#5
April 23rd, 2005, 04:28 PM
|
|||
|
|||
|
Typo Niek:
"And, with the 4th argument as FALSE, the table (Column A) has to be sorted ascending" -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "Niek Otten" wrote in message ... Hi Alan, Are both items numeric or text? Check this with =ISTEXT or ISNUMBER, even if they look the same. And, with the 4th argument as FALSE, the table (Column A) has to be sorted ascending. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Alan" wrote in message ... Bob Sorry already tried that ... HAve used VLOOKUP before and this has me stumped ! Thanks anyways ... open to other suggestions "Bob Phillips" wrote: Alan, Check that the lookup value and the unique ids are exactly the same. On a matching item, do a LEN(C3) and LEN(Ax) to see that there are no extraneous spaces in there. -- HTH RP (remove nothere from the email address if mailing direct) "Alan" wrote in message ... I have a Workbook with multiple sheets.... On one sheet I have a unique identifier which provides me with certain information and have acquired another which gives me more, but also has the same unique identifier... I wish to import this into the one sheet for reference, however this is not performing as expected. THe sheet I am trying to copy from has 2 columns of data column 1 being the unique index and column 2 being the data to be copied I have used a VLOOKUP function on the main page viz: =VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the unique index in the main sheet. I am however getting the error "Value not available" although doing an individual find on the other sheet finds it is there ??? Any help greatfully appreciated Alan
|
|
#6
April 23rd, 2005, 04:55 PM
|
|||
|
|||
|
"RagDyeR" wrote in message ... Typo Niek: "And, with the 4th argument as FALSE, the table (Column A) has to be sorted ascending" -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "Niek Otten" wrote in message ... Hi Alan, Are both items numeric or text? Check this with =ISTEXT or ISNUMBER, even if they look the same. And, with the 4th argument as FALSE, the table (Column A) has to be sorted ascending. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Alan" wrote in message ... Bob Sorry already tried that ... HAve used VLOOKUP before and this has me stumped ! Thanks anyways ... open to other suggestions "Bob Phillips" wrote: Alan, Check that the lookup value and the unique ids are exactly the same. On a matching item, do a LEN(C3) and LEN(Ax) to see that there are no extraneous spaces in there. -- HTH RP (remove nothere from the email address if mailing direct) "Alan" wrote in message ... I have a Workbook with multiple sheets.... On one sheet I have a unique identifier which provides me with certain information and have acquired another which gives me more, but also has the same unique identifier... I wish to import this into the one sheet for reference, however this is not performing as expected. THe sheet I am trying to copy from has 2 columns of data column 1 being the unique index and column 2 being the data to be copied I have used a VLOOKUP function on the main page viz: =VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the unique index in the main sheet. I am however getting the error "Value not available" although doing an individual find on the other sheet finds it is there ??? Any help greatfully appreciated Alan
|
|
#7
April 23rd, 2005, 04:57 PM
|
|||
|
|||
|
Hi RagDyeR,
I'm sure you're right. I just fail to see the typo! Please help. -- Kind Regards, Niek Otten Microsoft MVP - Excel "RagDyeR" wrote in message ... Typo Niek: "And, with the 4th argument as FALSE, the table (Column A) has to be sorted ascending" -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "Niek Otten" wrote in message ... Hi Alan, Are both items numeric or text? Check this with =ISTEXT or ISNUMBER, even if they look the same. And, with the 4th argument as FALSE, the table (Column A) has to be sorted ascending. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Alan" wrote in message ... Bob Sorry already tried that ... HAve used VLOOKUP before and this has me stumped ! Thanks anyways ... open to other suggestions "Bob Phillips" wrote: Alan, Check that the lookup value and the unique ids are exactly the same. On a matching item, do a LEN(C3) and LEN(Ax) to see that there are no extraneous spaces in there. -- HTH RP (remove nothere from the email address if mailing direct) "Alan" wrote in message ... I have a Workbook with multiple sheets.... On one sheet I have a unique identifier which provides me with certain information and have acquired another which gives me more, but also has the same unique identifier... I wish to import this into the one sheet for reference, however this is not performing as expected. THe sheet I am trying to copy from has 2 columns of data column 1 being the unique index and column 2 being the data to be copied I have used a VLOOKUP function on the main page viz: =VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the unique index in the main sheet. I am however getting the error "Value not available" although doing an individual find on the other sheet finds it is there ??? Any help greatfully appreciated Alan
|
|
#8
April 23rd, 2005, 05:07 PM
|
|||
|
|||
|
I believe he meant that if the 4th argument is FALSE you won't need any
sorting -- Regards, Peo Sjoblom "Niek Otten" wrote in message ... Hi RagDyeR, I'm sure you're right. I just fail to see the typo! Please help. -- Kind Regards, Niek Otten Microsoft MVP - Excel "RagDyeR" wrote in message ... Typo Niek: "And, with the 4th argument as FALSE, the table (Column A) has to be sorted ascending" -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "Niek Otten" wrote in message ... Hi Alan, Are both items numeric or text? Check this with =ISTEXT or ISNUMBER, even if they look the same. And, with the 4th argument as FALSE, the table (Column A) has to be sorted ascending. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Alan" wrote in message ... Bob Sorry already tried that ... HAve used VLOOKUP before and this has me stumped ! Thanks anyways ... open to other suggestions "Bob Phillips" wrote: Alan, Check that the lookup value and the unique ids are exactly the same. On a matching item, do a LEN(C3) and LEN(Ax) to see that there are no extraneous spaces in there. -- HTH RP (remove nothere from the email address if mailing direct) "Alan" wrote in message ... I have a Workbook with multiple sheets.... On one sheet I have a unique identifier which provides me with certain information and have acquired another which gives me more, but also has the same unique identifier... I wish to import this into the one sheet for reference, however this is not performing as expected. THe sheet I am trying to copy from has 2 columns of data column 1 being the unique index and column 2 being the data to be copied I have used a VLOOKUP function on the main page viz: =VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the unique index in the main sheet. I am however getting the error "Value not available" although doing an individual find on the other sheet finds it is there ??? Any help greatfully appreciated Alan
|
|
#9
April 23rd, 2005, 08:03 PM
|
|||
|
|||
|
Glad this isn't color TV!
-- Kind Regards, Niek Otten Microsoft MVP - Excel "Peo Sjoblom" wrote in message ... I believe he meant that if the 4th argument is FALSE you won't need any sorting -- Regards, Peo Sjoblom "Niek Otten" wrote in message ... Hi RagDyeR, I'm sure you're right. I just fail to see the typo! Please help. -- Kind Regards, Niek Otten Microsoft MVP - Excel "RagDyeR" wrote in message ... Typo Niek: "And, with the 4th argument as FALSE, the table (Column A) has to be sorted ascending" -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "Niek Otten" wrote in message ... Hi Alan, Are both items numeric or text? Check this with =ISTEXT or ISNUMBER, even if they look the same. And, with the 4th argument as FALSE, the table (Column A) has to be sorted ascending. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Alan" wrote in message ... Bob Sorry already tried that ... HAve used VLOOKUP before and this has me stumped ! Thanks anyways ... open to other suggestions "Bob Phillips" wrote: Alan, Check that the lookup value and the unique ids are exactly the same. On a matching item, do a LEN(C3) and LEN(Ax) to see that there are no extraneous spaces in there. -- HTH RP (remove nothere from the email address if mailing direct) "Alan" wrote in message ... I have a Workbook with multiple sheets.... On one sheet I have a unique identifier which provides me with certain information and have acquired another which gives me more, but also has the same unique identifier... I wish to import this into the one sheet for reference, however this is not performing as expected. THe sheet I am trying to copy from has 2 columns of data column 1 being the unique index and column 2 being the data to be copied I have used a VLOOKUP function on the main page viz: =VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the unique index in the main sheet. I am however getting the error "Value not available" although doing an individual find on the other sheet finds it is there ??? Any help greatfully appreciated Alan
|
|
#10
April 24th, 2005, 05:56 AM
|
|||
|
|||
|
Actually, it is Niek.
In my O.E., watched messages are red, So ... since you're watched, you're RED!bg -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Niek Otten" wrote in message ... Glad this isn't color TV! -- Kind Regards, Niek Otten Microsoft MVP - Excel "Peo Sjoblom" wrote in message ... I believe he meant that if the 4th argument is FALSE you won't need any sorting -- Regards, Peo Sjoblom "Niek Otten" wrote in message ... Hi RagDyeR, I'm sure you're right. I just fail to see the typo! Please help. -- Kind Regards, Niek Otten Microsoft MVP - Excel "RagDyeR" wrote in message ... Typo Niek: "And, with the 4th argument as FALSE, the table (Column A) has to be sorted ascending" -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "Niek Otten" wrote in message ... Hi Alan, Are both items numeric or text? Check this with =ISTEXT or ISNUMBER, even if they look the same. And, with the 4th argument as FALSE, the table (Column A) has to be sorted ascending. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Alan" wrote in message ... Bob Sorry already tried that ... HAve used VLOOKUP before and this has me stumped ! Thanks anyways ... open to other suggestions "Bob Phillips" wrote: Alan, Check that the lookup value and the unique ids are exactly the same. On a matching item, do a LEN(C3) and LEN(Ax) to see that there are no extraneous spaces in there. -- HTH RP (remove nothere from the email address if mailing direct) "Alan" wrote in message ... I have a Workbook with multiple sheets.... On one sheet I have a unique identifier which provides me with certain information and have acquired another which gives me more, but also has the same unique identifier... I wish to import this into the one sheet for reference, however this is not performing as expected. THe sheet I am trying to copy from has 2 columns of data column 1 being the unique index and column 2 being the data to be copied I have used a VLOOKUP function on the main page viz: =VLOOKUP(C3,WorkNo!A2:B8200,2,FALSE) where C3 is the location of the unique index in the main sheet. I am however getting the error "Value not available" although doing an individual find on the other sheet finds it is there ??? Any help greatfully appreciated Alan
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| vlookup data hidden within worksheet | Worksheet Functions | 0 | January 26th, 2005 12:09 PM | |
| Insert Vlookup into table_array of Vlookup with named range | Denise | Worksheet Functions | 1 | January 24th, 2005 10:49 PM |
| VLOOKUP and IF statements | JAnderson | General Discussion | 2 | August 4th, 2004 11:39 PM |
| Need help with VLOOKUP | Frank Kabel | Worksheet Functions | 4 | January 17th, 2004 11:24 PM |
| VLookup Help | Robert | Worksheet Functions | 5 | December 3rd, 2003 12:57 AM |
Linear Mode
