Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how do I read this part of a vlookup statement !1:65536,12,FALSE

I have a spreadsheet that needs to be updated, and this one statement is not
working. The other sheets are linked to an access query with pivot tables.
Once they are updated the sumary page pulls from that with this statement, I
just do not know what this references?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 427
Default how do I read this part of a vlookup statement !1:65536,12,FALSE

You've left some portion of the VLOOKUP formula out of your post, but
essentially the formula says, "in a particular sheet, look in column A
for a particular value and when you find the first exact match, return
the value in column L from that row".

FALSE in that context is an parameter of the lookup that returns only
an exact match.

Your post doesn't mention what value is returned for that VLOOKUP, but
if it is #REF it can mean that the tab from which the lookup is pulling
the data has been deleted.

Dave O

Reply
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 referencing one column that contains part numbers in both. crafty_girl Excel Worksheet Functions 2 April 18th 06 07:29 PM
VLookup Error in Part of a Named Range Dallas64 Excel Worksheet Functions 6 April 18th 06 02:13 PM
read in Vlookup an argument that has quotations(") carlosgdlf Excel Discussion (Misc queries) 1 August 2nd 05 05:56 PM
Vlookup for part of a word jenhow Excel Worksheet Functions 7 April 29th 05 10:22 PM
vlookup to extract part cell content excelFan Excel Discussion (Misc queries) 2 December 5th 04 08:45 AM


All times are GMT +1. The time now is 09:03 AM.

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

About Us

"It's about Microsoft Excel"