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: 788
Default Simple VLOOKUP problem

I am a first time user of the VLOOKUP function so am sure I have missed
something basic but can't see what it is. The formula is returning #N/A
despite the value being in the table array. The formula I have is:

=VLOOKUP(D3,$I$3:$J:$361,2,TRUE)

I am basically trying to lookup a name in D3 and match it with the
corresponding name in the table I3:J361 and then return the value in column 2
of the table. If I do =D3=I1340 then TRUE is returned so the formatting
appears to be the same.

Anyone have any ideas whatsoever???

 
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 yvette Excel Worksheet Functions 7 November 2nd 06 06:31 PM
Problem with VLOOKUP in 2003. Carlgru Excel Worksheet Functions 2 September 27th 06 08:04 PM
Vlookup problem.. Neo1 Excel Worksheet Functions 5 March 16th 06 09:53 AM
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? Steve Excel Worksheet Functions 0 January 30th 05 09:11 PM
VLOOKUP problem Jason Excel Worksheet Functions 2 January 14th 05 10:39 PM


All times are GMT +1. The time now is 04:15 AM.

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"