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 |
#11
|
|||
|
|||
I have had this same type of problem before. Hopefully you don't do the same
stupid things I do but, Have you tried it with the Equation having true in the last spot to just make sure the sheet references are correct? Have you tried something like = match((C3,WorkNo!A2:B8200,0) to see if it recognizes the identity in other than Vlookup I had one workbook I inherited, in which that the Vlookup never did work and I had to use the equivelent of =index(WorkNo!A2:B8200,Match(C3,WorkNo!A2:AB8200,0 ) "Alan" wrote: 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 |