Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Excel
123quattro
charting
crashesgpfs
datamap
excel
interopoledde
links
misc
newusers
printing
programming
querydao
sdk
setup
templates
worksheet.functions
  
 
date: Fri, 10 Oct 2008 14:22:18 -0700,    group: microsoft.public.excel        back       


Vlookup   
Keep getting a n/a#
Trying to pull second and third column pff a different worksheet
Says my lookup value is the problem
-- 
Mike Fitz
date: Fri, 10 Oct 2008 14:22:18 -0700   author:   fitzsociety

RE: Vlookup   
=VLOOKUP(F3,Table!$B$3:$D$957,2,FALSE)
=VLOOKUP(,Table!$B$3:$D$957,3,FALSE)

These are the two functions i used...Help Please
-- 
Mike Fitz


"fitzsociety" wrote:

> Keep getting a n/a#
> Trying to pull second and third column pff a different worksheet
> Says my lookup value is the problem
> -- 
> Mike Fitz
date: Fri, 10 Oct 2008 14:26:01 -0700   author:   fitzsociety

Re: Vlookup   
Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html  (for =vlookup())
and
http://contextures.com/xlFunctions02.html#Trouble

fitzsociety wrote:
> 
> Keep getting a n/a#
> Trying to pull second and third column pff a different worksheet
> Says my lookup value is the problem
> --
> Mike Fitz

-- 

Dave Peterson
date: Fri, 10 Oct 2008 16:27:22 -0500   author:   Dave Peterson

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us