 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2008VLOOKUP problem (N/V)
I have 2 sheets. In one i make calculations in other i have data (DataSheet) Id like to extract exact data from my data sheet. I have unique identifiers in both sheets for the same items, so I tried to extract data using vlookup: =VLOOKUP(R3;'DataSheet'!1:22;7;FALSE) in cell R3 is the unique id. (for example: ES0313860159) - and exactly the same ID is in the 'DataSheet' but then instead of getting the value from column 7 in DataSheet which i was looking for i get the result N/V whats wrong? Maybe the value on one or other sheets has leading or trailing spaces. Check them both out using =LEN(cell)  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) >I have 2 sheets. In one i make calculations in other i have data > (DataSheet) [quoted text clipped - 12 lines] > > whats wrong? > Maybe the value on one or other sheets has leading or trailing spaces. > [quoted text clipped - 26 lines] > > - Show quoted text - checked - there are no spaces Your table range is set up for rows 1:22 - you probably need to set this for columns A:V, or change the VLOOKUP to HLOOKUP. Hope this helps. Pete > > >I have 2 sheets. In one i make calculations in other i have data > > > (DataSheet) [quoted text clipped - 12 lines] > > > > whats wrong > Your table range is set up for rows 1:22 - you probably need to set > this for columns A:V, or change the VLOOKUP to HLOOKUP. [quoted text clipped - 21 lines] > > - Show quoted text - no still not working. i tried EXACT on both IDs and it returns TRUE, so the to IDs must be the same... i just dont get it. I also tried MATCH, which also returns N/V... is there a problem with the ID being to long to work or what else could be the problem... That works fine Pete. Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) Your table range is set up for rows 1:22 - you probably need to set this for columns A:V, or change the VLOOKUP to HLOOKUP. Hope this helps. Pete On Feb 4, 10:48 am, Mortir <mare.roz...@gmail.com> wrote: > > >I have 2 sheets. In one i make calculations in other i have data > > > (DataSheet) [quoted text clipped - 12 lines] > > > > whats wrong > Maybe the value on one or other sheets has leading or trailing spaces. > [quoted text clipped - 26 lines] > > - Show quoted text - guys forget it. I made the mistake - i forgot that the lookup value should be in the FIRST column of the array (banging the head against the wall!!!) 10x for your help! OK. Glad you got it working. Pete > > Maybe the value on one or other sheets has leading or trailing spaces. > [quoted text clipped - 38 lines] > > - Show quoted text - |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.