LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 34
Default VLOOKUP 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vlookup problem Robbyn Excel Worksheet Functions 10 August 6th 07 02:49 AM
VLOOKUP problem fastballfreddy Excel Worksheet Functions 3 May 16th 06 11:53 AM
VLOOKUP problem using VBA matpj Excel Discussion (Misc queries) 4 April 28th 06 12:07 PM
vlookup problem shrutikhurana Excel Discussion (Misc queries) 2 February 9th 06 01:52 PM
VLOOKUP problem Wazooli Excel Discussion (Misc queries) 5 March 26th 05 01:52 PM


All times are GMT +1. The time now is 09:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"